Creating a RAG report where i will format background Red Amber Green based on the values in 2 columns.
RULES
If col H is greater than 1 then it is GREEN.
If col H is less than 1 AND col K is less than 1, then RED
If col H is less than 1 AND col K is greater than 1 then AMBER
Here is how I wrote it...
=
IF(H1>=1,"Green",
IF(AND(H1<1,K1<1),"Red",
IF(AND(H1<1,K1>=1),"Amber")))
It doesn't seem to be giving me the correct data. Some are right, some are wrong.
