You would use FormatConditional Formatting for this.

Select the column in question(I'll assume A).

FormatConditional FormattingFormula is:

enter =A1="I" FormatPattern RedOK

Add =A1="A" FormatPattern GreenOK

Note: you can use up to three conditional formats(four if you count default)

Gord Dibben Excel MVP



On Fri, 23 Apr 2004 16:55:32 -0500, djranks
wrote:

i have an account spreadsheet. with a column heading reading status.
How can i tell excel to highlight all cells containing status "I" for
inactive in red, and status "A" for active in green?


---
Message posted from http://www.ExcelForum.com/