Event - DATE START - DATE END
On sheet 2 i have a Year Calander (365 Days)I need to do a conditional formatting to highlight the days which i have events.The 6 is just a start and the list will go longer...I want to have a pictorial view of the calendar on where the events fall in the year which is SHEET 2.
Sheet 1 i just key in the dates for the start and end....
How to change year
You can change the year in cell K2 and the calendar changes almost instantly.
How to add or remove events
The events are in an excel defined table. You can add or remove rows by right clicking on a cell and select Insert or Delete.
You can also add a blank row by selecting the last cell in the table.
Press Tab key.
You can move the table to any sheet you like.
How to change formatting color
- Select cell range B6:X38
- Go to tab "Home"
- Click "Conditional formatting" button
- Click "Manage Rules..."
- Select the rule with grey formatting
- Click "Edit Rule..." button
- Click "Format..." button
- Go to tab "Fill"
- Pick a different color
- Click OK
- Click OK