Forum Discussion
RAG Status help
Let's say for a budget cell a1 has the actual figure, cell b1 has the budget figure, and cell c1 has the variance figure. In d1 i need a RAG status whereby if the actual figure is over 10% of the...
In the screenshot, the formula in D2 is =C2, so that it contains the same percentage.
A conditional formatting rule hides the value and displays a red/amber/green stoplight icon.