Hello, newbie here!
Can someone help me with conditional formatting e.g.
A1 has a figure of 81%
B1 has a figure of 89%
I want A1 shaded green if it's equal to or above B1.
I also want A1 shaded yellow if it's within 2% of B1 (so either 87% or 88%)
I also want A1 shaded red if it's less than the 2% threshold (e.g. 86% or less).
Thank you!
Can someone help me with conditional formatting e.g.
A1 has a figure of 81%
B1 has a figure of 89%
I want A1 shaded green if it's equal to or above B1.
I also want A1 shaded yellow if it's within 2% of B1 (so either 87% or 88%)
I also want A1 shaded red if it's less than the 2% threshold (e.g. 86% or less).
Thank you!