Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting help (2003)
Hi all,
I am trying to apply conditional formatting to A1 where if B2 is greater than or equal to 20 (green), if between 14 and 19 (amber) and if less than or equal to 13 (red). Any help greatly appreciated Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting help (2003)
Hi Jooniper,
Am Thu, 27 Jun 2013 09:45:33 +0100 schrieb Jooniper: I am trying to apply conditional formatting to A1 where if B2 is greater than or equal to 20 (green), if between 14 and 19 (amber) and if less than or equal to 13 (red). format A1 with red back color. Then select A1 = CF = use formula: =B1=20 for green and =B1=14 for amber The rule for green color has to be rule 1 Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting from 2007 to 2003 | Excel Discussion (Misc queries) | |||
EXCEL 2003 - Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting - 2003 to 2007 | Excel Discussion (Misc queries) | |||
Conditional Formatting 2003 | Charts and Charting in Excel | |||
Excvel 2003: Conditional Formatting | Excel Discussion (Misc queries) |