Conditional Formatting help - colour and days
Closed
Bryony
-
Aug 26, 2010 at 09:38 AM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Sep 2, 2010 at 07:12 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Sep 2, 2010 at 07:12 PM
Related:
- Conditional Formatting help - colour and days
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Crimping colour code - Guide
- Conditional formatting if another cell contains any text ✓ - Excel Forum
- Skype last seen days ago - Guide
- Conditional format based on another cell containing text - Excel Forum
1 reply
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
25
Sep 2, 2010 at 07:12 PM
Sep 2, 2010 at 07:12 PM
In cell J8, set the conditional formatting to be:
Condition 1: Formula Is: =IF(A1="Wed",TRUE,IF(A1="Fri",TRUE,FALSE))
Condition 2: Formula Is: =IF(A1<>"Wed",IF(A1<>"Fri",TRUE,FALSE))
Choose your colours accordingly.
Condition 1: Formula Is: =IF(A1="Wed",TRUE,IF(A1="Fri",TRUE,FALSE))
Condition 2: Formula Is: =IF(A1<>"Wed",IF(A1<>"Fri",TRUE,FALSE))
Choose your colours accordingly.