Forum Discussion
Solved
Excel Yearly calender conditional formatting
Hey! I am trying to make a yearly calender and automatticly format certaint days of the week. This is what i have so far! I have a dropdown list which allows me to pick the year. And i've als...
Select the cells that you want to format conditionally.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Lave the first drop down set to 'Cell Value'.
Select 'equal to' from the second drop down.
Enter ="Sat" in the box next to it.
Click Format...
Activate the Fill tab.
Select green.
Click OK, then click OK again.
Repeat the above steps, but with ="Sun" instead of ="Sat".
I haved pmed you the file of data.
Solved via PM.