Conditional Formatting based of another cell
Closed
Delightful2k4
Posts
1
Registration date
Tuesday February 10, 2015
Status
Member
Last seen
February 10, 2015
-
Feb 10, 2015 at 04:27 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 16, 2015 at 11:52 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 16, 2015 at 11:52 AM
Related:
- Conditional Formatting based of another cell
- Conditional formatting if two cells match ✓ - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- How to change account based in instagram - Instagram Forum
- Excel conditional formatting if cell contains multiple specific text ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Feb 16, 2015 at 11:52 AM
Feb 16, 2015 at 11:52 AM
Hi Delightful2k4,
So I'm guessing you are looking for the formula to use for conditional formatting.
If I understand you correctly then this will work:
=AND(OR($C$2*1.25=$C$1,$C$2*0.75=$C$1),$C$1>20)
Now, for example, when C1 = 25 and C2 = 20 then C3 turns red.
Best regards,
Trowa
So I'm guessing you are looking for the formula to use for conditional formatting.
If I understand you correctly then this will work:
=AND(OR($C$2*1.25=$C$1,$C$2*0.75=$C$1),$C$1>20)
Now, for example, when C1 = 25 and C2 = 20 then C3 turns red.
Best regards,
Trowa