Look at conditional formatting
http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"m3s3lf" wrote in
message ...

I've got a date range on one sheet, and data on another. My data sheet
has a column of dates. I want to add a button next to my date ranges
to highlight the rows on my data sheet if they fall into that date
range. Does that make sense? Can anybody help me?
Thank you!
Billy


--
m3s3lf
------------------------------------------------------------------------
m3s3lf's Profile:
http://www.excelforum.com/member.php...o&userid=34874
View this thread: http://www.excelforum.com/showthread...hreadid=546223