Forum Discussion
RAG status help
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
Sure, I hope this makes more sense. The current RAG status for the negative budget makes sense. It's saying the actual figure was not as negative as budgeted, therefore it is good. However I need it to ignore this logic and apply a separate rule.
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
