Conditional formatting based on another cell?
Closed
JTTaylor92
Posts
1
Registration date
Thursday 19 January 2017
Status
Member
Last seen
19 January 2017
-
19 Jan 2017 à 20:42
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 23 Jan 2017 à 12:07
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 23 Jan 2017 à 12:07
Related:
- Conditional formatting based on another cell?
- Excel conditional formatting based on date - Guide
- Clear only the formatting from the selected cell - Guide
- Based on the values in cells b77 b88 ✓ - Excel Forum
- Return Seq Values Until Blank value then return different set of seq values ✓ - Excel Forum
- How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
23 Jan 2017 à 12:07
23 Jan 2017 à 12:07
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
