I copied and pasted this into my personal workbook and ran the macro. I
changed my date on my pc to the 14th of July and it highlights anything
with a value in K. No matter what the date is in M. Its set to
highlight anything with a date Date - 7 in column M, (which according
to my calculations is any date that's greater than July 7th. Problem is
it still highlights those whose dates are July 5th. That's not greater,
that's less than. Does it highlight those with those dates on your end
when you run it? Or am I doing something wrong??


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=387731