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.
Could you provide more examples, with the desired color manually indicated in a separate column?
Row 4 should be yellow, sorry