Highlight cell in an excel calendar matrix when date is today

[jameshelp]

I have built a simple calendar and want to highlight the correct cell if the date is today. I can't think of any way to do this, any help would be appreciated.

I have added a worksheet, the cell highlighted in magenta indicates the date is today.

Capturecal.PNG

[Pete_UK]

First remove the manual magenta in that cell, then select all the cells, i.e. from B2 to AF12 (though you picture shows different columns are used), and click on Conditional Formatting | New Rule | Use a formula... , then put this formula in the dialogue box which pops up:

=DATEVALUE(COLUMNS($B:B)&" "&$A2&2021)=TODAY()

Click on the Format button | Fill tab and choose your colour, then OK your way out.

Hope this helps.

Pete

[jameshelp]

Wow Pete, another quick solve. What a master. Thank you again

[Pete_UK]

Glad to help. The drawback is that the year is hard-coded within the CF formula. If you put the year in a cell somewhere (e.g. A1), then you could use $A$1 instead of 2021 in the formula, and it would work for different years.

You might also think about using CF to show weekend dates in a different colour.

Thanks for marking the thread as Solved, but you might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

[jameshelp]

Agreed and understood! Thanks again.