Managing rules on cells.

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 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
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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