Conditional Formatting - highlight the 1st of the month

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

Hi Adam,

Say you dates are in A1:A10, Select the range.

Go to CF, apply new rule. Put he rule in the formula box.

=DAY(A1)=1

and apply your format.

Thanks misrasomendra - that's exactly what I need. It's that simple that it's quite embarassing!

Thanks for the feedback, you are welcome back!!

Now can you kindly mark the thread as SOLVED and give me some reps point if you feel my suggestion had solved your problem.