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 date format dd.mm.yyyy - Guide
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Whatsapp date format - Guide
- If cell contains text then return value multiple conditions ✓ - Excel Forum
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
