If then date with conditional formatting

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I'm trying to make an if/then statement (If a date cell is Monday, then a Red fill is used). Does anyone know the formula


2 replies

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.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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