Conditional Font Color in Excel

Question

I would like to put an 'if' statement in an Excel spreadsheet, such that if the 'IF statement' is true, the cell would display the font in a color, say red, but if the statement is not true, the color remains black.  I use Excel 2003 and XP.   Is this possible?   Gary

racollins · Answer

You can use conditional formatting.  This feature allows you to have up to three conditions.  If any of these conditions are satisfied, then the formatting for that condition will take affect.

racollins · Answer

You can use conditional formatting.  With CF you have have up to three conditions.  Search Excel help for more details on how to use CF.

burtlake · Answer

Thanks.  Sounds like what I'm looking for.  Will give it a try.

Productivity Software

Was this post helpful?