Excel auto colour cell depending on text

[slames]

This is a really simple question, I just can't remember how to set it up. If a cell contains "#N/A", I want the text to appear white, otherwise I want tit to be black. I know somewhere there is a rule function in excel, How do I do it?
Thank You
Steph

 

[slames]

ok, I found the conditional format option, but I can't get it to change the font colour to white when #n/a appears in the cell. I want to hide the fact the equation exists behind these cells when none of the formula data is input. I have a formula running down the page, but the user may only input into the first half of the worksheet, or they may fill it. Is there a way around this?
Thanks
Steph

 

[GlennUK]

Use conditional formatting, Formula Is, with a formula of =ISNA(cell_ref)
and change the format to be white font.

Glenn.

 

[slames]

I've tried to do this by typing =isna into the box, but can't seem to get it to work - any ideas?

 

[GlennUK]

If you are really typing just =isna then it wont work. Are you typing =ISNA(cell_ref) in the formula box for conditional formatting? Where cell_ref is the reference of the active cell.

Glenn.

 

[slames]

Yes, that works now - thanks