field highlight

  • Thread starter Thread starter djranks
  • Start date Start date
D

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
 
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
 
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
 
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
 
Back
Top