Example
If A1 contains any date in the month of May, I want A2 to turn red because A1 falls within the month of May.
If the date is not in May then A2 is to remain white.
I have tried to use the conditional formatting but cannot get the syntax right to determine if the cell falls within a particular month.
Thanks in advance for any help.
John
Bookmarks