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?
- How to change account based in instagram - Instagram Forum
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Conditional formatting if two cells match ✓ - Excel Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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
