Excel 2002 conditional formating issues

[mumzee]

First issue...
managed to conditional format cells in a range of columns so that they turn colour when you type n/a in a cell...
now how can I have it put in the colour and not the typed n/a????
and will this be the same when I do it in Excel 2010?

 

[AlphaFrog]

now how can I have it put in the colour and not the typed n/a????

What do you mean by "not the typed n/a"? Do you mean the cell value has #N/A error as a result of a formula error? If yes, use something like this as the Conditional Formatting formula...

Formula is =ISNA(A1)

It should work in both 2002 and 2010.

 

[mumzee]

What I meant is I am wanting the cell to turn pink when I input N/A in the cell but I do not want the result to show the characters N/A just the colour.... thanks for your help!

 

[AlphaFrog]

In the Conditional Formatting, set the font and background colors the same color.

 

[mumzee]

thanks for suggestion... is this only way ..... or just most logical?

 

[AlphaFrog]

thanks for suggestion... is this only way ..... or just most logical?

If you use Conditional Formatting, it's both.