Forum Discussion
kitcatnj
May 01, 2024Copper Contributor
Nested If With And
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 ...
SergeiBaklan
May 01, 2024Diamond Contributor
=IF(H1>=1, "Green", IF(K1<1, "Red", "Amber" ) )