field highlight

[djranks]

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

 

[Gord Dibben]

You would use Format>Conditional Formatting for this.

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

Format>Conditional Formatting>Formula is:

enter =A1="I" Format>Pattern Red>OK

Add =A1="A" Format>Pattern Green>OK

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

Gord Dibben Excel MVP

 

[djranks]

it works pefectly fine. my heading is in a1 reads' Status.
my first selection is a2 which reads I. but my formula starts workin
from a3 and on. it skips a2 and does nothing with it. but it works fro
a3 and so o

 

[Gord Dibben]

So, you get red and green colored cells for instances of "I" or "A" except in
A2.

Right?

Don't know why A2 would not color Red if it indeed contains the letter I(or i,
CF is not case-sensitive).

Select A2 and check your CF formula is: for first and/or second condition.
Should read =A2="I" or =A2="A"

Gord