Conditional formatting based on another cell?
Closed
JTTaylor92
Posts
1
Registration date
Thursday January 19, 2017
Status
Member
Last seen
January 19, 2017
-
Jan 19, 2017 at 08:42 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 23, 2017 at 12:07 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 23, 2017 at 12:07 PM
Related:
- Conditional formatting based on another cell?
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Instagram account based in wrong country - Instagram Forum
- Excel macro to create new sheet based on value in cells - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jan 23, 2017 at 12:07 PM
Jan 23, 2017 at 12:07 PM
Hi JTTaylor92,
Select D3.
Open conditional formatting and choose to use formula.
=$E3="Yes" apply format.
Used range:=$D$3:$D$14
Here is a pic for clearification:
Not sure though, if this is any different for using a mac.
Best regards,
Trowa
Select D3.
Open conditional formatting and choose to use formula.
=$E3="Yes" apply format.
Used range:=$D$3:$D$14
Here is a pic for clearification:
Not sure though, if this is any different for using a mac.
Best regards,
Trowa
