Date Highlight on calendar

[BullseyeThor]

Hi everyone

I have a Calendar I use to keep a track of my staff's holidays and sickness within my team. I have attached to this post.

What I need to make using it easier for evryone is to have the current date highlighted when opened.

Each date is split into 3 cells, the first cell in the actual date, the second two cells are where I add names for sick or Holiday. I only need the first cell to highlight.

Is it possible and if so can you help me.

Year Planner 2012-13.xlsx

[DBY]

Hello
In my attached reply I've applied conditional formatting to your calendar that should turn the date cell Red when equal to Today(). To test it out, you can replace the Today() function in the Conditional formatting formula with a cell reference and enter some date values.

Hope this helps.
DBY

[BullseyeThor]

That's great thanks.