Highlight a Date Range

[m3s3lf]

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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

 

[m3s3lf]

I appreciate the response, especially so quickly, but...

conditional formatting doesn't work across 2 different sheets, and I
don't want it to always be highlighted... only when the user clicks the
button.

Thanks again,
Billy

 

[Ardus Petus]

Here's an example: http://cjoint.com/?fCgsQ0N5xN

HTH

 

[Bob Phillips]

I appreciate the response, especially so quickly, but...

conditional formatting doesn't work across 2 different sheets, and I
don't want it to always be highlighted... only when the user clicks the
button.

Of course it will, see this example

http://cjoint.com/?fClCwKV8Zw

 

[m3s3lf]

Of course it will, see this example

http://cjoint.com/?fClCwKV8Zw

Oh! Duh! By defining a name for the cells.... I should have thought of
that. Thanks so much for your help!
Billy