Forum Discussion
Solved
RAG status help
Hi, I've attached an example to help understanding. I have applied conditional formatting to visualise a RAG status. The payroll status is working fine, as long as the figure is below 1.05 it wil...
You cannot do that with a rule of type icon sets. It's possible with two rules of type 'Use a formula to determine which cells to format'.
See the attached version. The cells have green as default fill color; the rules apply yellow or red depending on a formula that refers to columns C and E.
Sure. I simply selected E2:E10 (or further down if required) and selected green as fill color.
In the attached version, the conditional formatting rules look at B2/C2 instead of at E2.
That allows us to clear the formulas from E2:E10.
Thanks Hans.