Exel: Change cell background color based cell value?

Question

I have a column with function values of True or False:

=IF(ISNA(A1), false, true)

from row 1 to 5000+ rows. I would like to mark all the False as red background color or text as red. Is there any function available?

Answer 1

First, you change your formula to

=ISNA(A1)

you don't need the IF part. Then use conditional formatting. First Select B1:B5000 (or whatever column your formula is in. Next Format - Conditional Formatting. Then choose Cell Values Is and type False into the box. Click the Format button to set the Pattern to red. Click OK.

Worksheet formulas can only return values. They cannot change other properties of the cell (like colors). Conditional Formatting is the way to go here.

Answer 2

I'm not very familiar with Excel but have you tried Conditional Formatting?
You can find it under

Toolbar->Format->Conditional Formatting

^{(Translated. I have a non english version of Office)}