Hello,

Is there a formula to use in conditional formatting that would do the following.

If 'B1' is between 0.01% and 20% the value of 'A1' = condition 1

ELSE IF 'B1' is between 20.01% and 75% the value of 'A1' = condition 2

ELSE IF 'B1' is over 75% the value of 'A1' = condition 3

Thanks,

Ben