Excel - Conditional Formatting and #N/A 2

[shytott]

Hi
Is it possible to apply Conditional Formatting to a cell whose formula has returned 'Number Not Available' – ie '#N/A' It is possible for some cells on my spreadsheet to display this and I would like to blank it out visually by changing the text colour to match the background but only when it displays #N/A. I have already tried setting the C Format to ‘Cell is equal to’ ”#N/A” but this has no effect. Any help would be much appreaciated.


Many Thanks

 

[bluedragon2]

Instead of using CF, you could put error checking in your formula to display a blank cell if you get that error.

If you want to use CF, use the formula if iserror...

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[SkipVought]

In Formula Is: =ISNA(YourCellRef)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[shytott]

Fabulous - Thanks Guys
45 mins wasted trying myself, and 5-6 mins in here and its cracked!

Many Thanks
AD