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.
I should have asked this along with the other question, but is it also possible to hide the figures in the RAG too? So it only displays the fill colour. Thanks
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.