Use conditional formatting:


Select a date cell (say A1) and pull-down
Format Conditional Formatting... then select Formula is and enter:
=(MONTH(A1)=MONTH(TODAY())) and then pick a hi-light format

Then copy the format down the column.

This will hi-light all the dates in the current month. The dates don't even
have to be sorted.
--
Gary's Student


"matpj" wrote:


Hi guys/gals,

I have a worksheet with 3 columns on it:
Version, Type, Release Date

I need to be able to analyse the date and when a version's Release Date
is in the current month, I need to display a message or some other
notification.

Can anyone tell me how this might be possible.

thanks in advance,
Matt


--
matpj
------------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=527121