ExcelBanter - Conditional Formatting and Percentages of a set target

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Conditional Formatting and Percentages of a set target (https://www.excelbanter.com/excel-programming/382249-conditional-formatting-percentages-set-target.html)

[email protected]

Conditional Formatting and Percentages of a set target

I have to color code several cells depending whether they are on
target or not.

Ex.
100% of Target = Green

90-100% of Target = Yellow

<90% of target = Red

Any help would be much appreciated.

James

All times are GMT +1. The time now is 08:13 PM.