Previous Topic Next Topic

Managing rules on cells.

Closed
a - Dec 10, 2010 at 09:07 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 20, 2010 at 09:13 AM
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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Dec 20, 2010 at 09:13 AM
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
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response
Comparing columns and returning value
ll -
kittu -

35 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses