Managing rules on cells. [Closed]

Report
-
Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
-
Hello,

I have a series of cells beside each other that contain different values. I need a formula that will adjust for the following: If the second cell value is less than or greater than 10% of the first cell value (and so on) and if so could it change colour?

Many Thanks.

A


1 reply

Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
Hi A,

When using row 1 for data entry use the following formula in the conditional format menu: =AND(B1>=A1*0.9,B1<=A1*1.1)
Now drag B1 till the end of the row and select the option of changing format only.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!