If then date with conditional formatting
Closed
Joe
-
Jul 7, 2010 at 06:01 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 7, 2010 at 06:50 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 7, 2010 at 06:50 PM
Related:
- If then date with conditional formatting
- Excel conditional formatting based on date - Guide
- How to clear formatting in excel - Guide
- How to change date format in excel - Guide
- Formatting windows 7 - Guide
- 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 January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 7, 2010 at 06:50 PM
Jul 7, 2010 at 06:50 PM
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
