Change text colour

S

Shaijuzacharia

I have given the below formula and this gives #NA in columns with no
values. I want to change the font colour to white if the cell has #NA.

=IF(ISERROR(100*(AF5-AH5)/AH5),NA(),100*(AF5-AH5)/AH5)
 
D

David Biddulph

Format/ Conditional Format/ Formula Is:
=ISNA(...cell reference...)
Set font colour to white
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula help 5
custom add formula 7
Excel Named Ranges and Conditional Format 3
FIND type mismatch error, but don't see it 7
error value in axis 1
Really need some help with a tricky formula 8
Word Using the 'IF' Formula in MS Word 2010 0
Exclude Null Field in Formula 2

Top