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?
First, you change your formula to
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.
I'm not very familiar with Excel but have you tried
(Translated. I have a non english version of Office)