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 |
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 |
All times are GMT +1. The time now is 05:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com