Hi everyone,

This might be really simple, but i'm trying to work out how I can highlight a cell when it contains the 1st of each month...any month.

So, my spreadhsheet will have a load of dates in column A, and all I want to do is highlight those that are the 1st of the month.

The reason I ask is that when the cell highlights, it will trigger the user to be mindful that they need to take an action to do something else!

Any ideas?

Thanks
Adam