Conditional Formatting in Excel

Conditional Formatting in Excel
Always wanted to do this but never found the time to use it for something useful. Now I paint the days in the calendar, depending on whether the "Annual Leave" box is ticked.