Conditional Formatting help - colour and days
Closed
Bryony
-
Aug 26, 2010 at 09:38 AM
RayH
RayH
- Posts
- 122
- Registration date
- Tuesday August 31, 2010
- Status
- Contributor
- Last seen
- June 20, 2016
Related:
- Conditional Formatting help - colour and days
- Conditional formatting if cell does not contain specific text ✓ - Forum - Excel
- Conditional formatting if another cell contains any text ✓ - Forum - Excel
- Excel conditional formatting 5 color scale ✓ - Forum - Excel
- Copy conditional formatting from one row to another ✓ - Forum - Excel
- If cell contains date then conditional format - Guide
1 reply
RayH
Sep 2, 2010 at 07:12 PM
- Posts
- 122
- Registration date
- Tuesday August 31, 2010
- Status
- Contributor
- Last seen
- June 20, 2016
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.
