I have an average value for Agents(A) and I want to color this value regarding to another average value(B).
If A decreased by 15% from B I will color the A cell with RED.
Can anyone help me with this formula please :)
Thanks, I appreciate it
CodePudding user response:
A formula for conditional formatting must have TRUE
or FALSE
as a result, so you might try the following:
=IF(C3<0,65*C2,TRUE,FALSE)
I tried this for the values 1-5 and these are the results (Waar=TRUE and Onwaar=False):
CodePudding user response:
=A1<=B1*0.85
as rule for conditional formatting in column A (starting row 1) with format red.