If then date with conditional formatting
Closed
Joe
-
7 Jul 2010 à 18:01
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 7 Jul 2010 à 18:50
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 7 Jul 2010 à 18:50
Related:
- If then date with conditional formatting
- Excel conditional formatting based on date - Guide
- Excel clear formatting - Guide
- How to change date format in excel - Guide
- Excel conditional formatting dates overdue ✓ - Excel Forum
- How to change date format in openoffice - Guide
2 responses
Select all the data. Click conditional formatting (under Format).
Select "Cell value is", "Equal to", in the box type in ="Sunday"
Click "format..." then "Patterns" and select the color you want to fill the cells with.
Select "Cell value is", "Equal to", in the box type in ="Sunday"
Click "format..." then "Patterns" and select the color you want to fill the cells with.
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
7 Jul 2010 à 18:50
7 Jul 2010 à 18:50
You can use Weekday function. How ever, in conditional format, you may not have more than three conditions. So if you plan to color each day differently you have to use macro
