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 December 27, 2022 - Feb 16, 2015 at 11:52 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 16, 2015 at 11:52 AM
Related:
- Conditional Formatting based of another cell
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Instagram account based in wrong country - Instagram Forum
- If a cell has text then return value ✓ - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
- 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
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
