Conditional Formatting - Traffic Light System

[Alan L 185]

Hi

I’m trying to develop a ‘traffic light’ system using a formula in conditional formatting to show changes in budget requests compared to the previous year.

I’m proficient at using conditional formatting, I just need formulae for 1, 2 and 3 below.

1. If C2 is <= B2 then C2 is highlighted green.
2. If C2 is between >=1 and <=10% more than B2 then C2 is highlighted orange.
3. If C2 is > 10% more than B2 then C2 is highlighted red.

Please see the example attached.

Thanks in advance for your help.

[zzzeddy]

Hi Alan

The attached workbook has conditional formatting rules for the cell range [C2:C8].
You would need to adjust the 'applies-to' range for the rules as you add data rows etc etc etc

zeddy
Excel Genetic Baggage Handler

[Alan L 185]

Awesome. Thanks zzzeddy. A simple solution to my problem. I can throw away all the formulae I was trying to develop.

All the best,

AlanL