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".
That suggests that the name of the sheet is spelled incorrectly. Could there be a space before or after the name in the sheet tab, for example 'Vakantie gastouder ' ?
Wait i realise what i've done. Fixed it. Thought vakantie gastouder wasn't the sheet but just a ALTText bassicly. I thought it had to do to cell calling but it was sheet instead. Got it! Now just need to apply this trick one more time and i should have all the things i need. U have been amazing.