Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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.

share|improve this answer
OK. I see your point. Another option may be to write a snip of VBA macro to loop the range to change cell or row color (text or background). By the way, I prefer True and False values. In the example, A1 actually contains another formula so ISNA() will always returns False. – Mar 31 '10 at 22:11

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)

share|improve this answer
Is is nice. However, I have to apply the style to 5000+ rows. Not sure if there is function available to do it so that I can copy and paste. – Mar 31 '10 at 21:42
OK. I can do copy first and then select a range, right click, and finally select Paste Special->Format. – Mar 31 '10 at 21:48

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.