nparsons75
Well-known Member
- Joined
- Sep 23, 2013
- Messages
- 1,254
- Office Version
- 2016
Hi,
I need to setup conditional formatting to show a different colour based on how close to a target we are. In the table below for example,
If we are less than 70% of the target the colour is set to red.
Between 70% and 90% the colour is amber.
90% and above is green.
The colour scale is an example and the % ranges may need to be altered but hopefully the table below will show what I am hoping for.
Thanks in advance.
I need to setup conditional formatting to show a different colour based on how close to a target we are. In the table below for example,
If we are less than 70% of the target the colour is set to red.
Between 70% and 90% the colour is amber.
90% and above is green.
The colour scale is an example and the % ranges may need to be altered but hopefully the table below will show what I am hoping for.
Thanks in advance.
Cell Formulas | ||
---|---|---|
Range | Formula | |
B3:F3 | B3 | =B2/B1 |