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
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
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
Related:
- Managing rules on cells.
- Muvizu rules free download - Download - 3D modeling
- Outlook rules not working - Guide
- Rules of survival downloadable content - Download - Battle royale
- How would you change all cells containing the word pass to green - Excel Forum
- Based on the values in cells b77 ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 20, 2010 at 09:13 AM
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
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
