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 555
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
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Excel function question
1234ah -
ac3mark -

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

1 response
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response