If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
field highlight
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/ |
#2
|
|||
|
|||
field highlight
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/ |
#3
|
|||
|
|||
field highlight
it works pefectly fine. my heading is in a1 reads' Status.
my first selection is a2 which reads I. but my formula starts working from a3 and on. it skips a2 and does nothing with it. but it works from a3 and so on --- Message posted from http://www.ExcelForum.com/ |
#4
|
|||
|
|||
field highlight
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 On Fri, 23 Apr 2004 17:44:04 -0500, djranks wrote: it works pefectly fine. my heading is in a1 reads' Status. my first selection is a2 which reads I. but my formula starts working from a3 and on. it skips a2 and does nothing with it. but it works from a3 and so on --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|