nparsons75
Well-known Member
- Joined
- Sep 23, 2013
- Messages
- 1,256
- Office Version
- 2016
I have a table as below. I need the cell AVG ALL to be conditionally formatted to show the following...
If AVG ALL is less than TARGET by no more than 5% then fill colour AMBER.
If AVG ALL is less than TARGET by more than 5% then fill colour RED.
If AVG ALL is equal to or more than TARGET then fill colour GREEN.
The current result for AVG ALL would be RED. If the value was 86% for example, the colour would be AMBER.
Appreciate any help. Thanks in advance...
If AVG ALL is less than TARGET by no more than 5% then fill colour AMBER.
If AVG ALL is less than TARGET by more than 5% then fill colour RED.
If AVG ALL is equal to or more than TARGET then fill colour GREEN.
The current result for AVG ALL would be RED. If the value was 86% for example, the colour would be AMBER.
Appreciate any help. Thanks in advance...
| TARGET | AVG 20 | AVG 21 | AVG ALL |
| 88% | 79% | 75% | 79% |
