Home > Software engineering >  Conditional Formatting Excel Formula
Conditional Formatting Excel Formula

Time:12-31

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):

enter image description here

CodePudding user response:

=A1<=B1*0.85 as rule for conditional formatting in column A (starting row 1) with format red.

  • Related