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" <m3s3lf.28ht5y_1148778001.7478@excelforum-nospam.com> wrote in
message news:m3s3lf.28ht5y_1148778001.7478@excelforum-nospam.com...
>
> 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
>

[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

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

--
HTH

Bob Phillips

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

"m3s3lf" <m3s3lf.28ht5y_1148778001.7478@excelforum-nospam.com> wrote in
message news:m3s3lf.28ht5y_1148778001.7478@excelforum-nospam.com...
>
> 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
>

[Ardus Petus]

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

HTH
--
AP

"m3s3lf" <m3s3lf.28hv0m_1148780401.439@excelforum-nospam.com> a écrit dans
le message de news: m3s3lf.28hv0m_1148780401.439@excelforum-nospam.com...
>
> 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
>
> Bob Phillips Wrote:
>> Look at conditional formatting
>> http://www.contextures.com/xlCondFormat01.html
>>
>> --
>> HTH
>>
>> Bob Phillips
>>
>> (replace somewhere in email address with googlemail if mailing direct)
>>
>> "m3s3lf" <m3s3lf.28ht5y_1148778001.7478@excelforum-nospam.com> wrote
>> in
>> message news:m3s3lf.28ht5y_1148778001.7478@excelforum-nospam.com...
>> >
>> > 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
>> >
>
>
> --
> m3s3lf
> ------------------------------------------------------------------------
> m3s3lf's Profile:
> http://www.excelforum.com/member.php...o&userid=34874
> View this thread: http://www.excelforum.com/showthread...hreadid=546223
>

[Bob Phillips]

"m3s3lf" <m3s3lf.28hv0m_1148780401.439@excelforum-nospam.com> wrote in
message news:m3s3lf.28hv0m_1148780401.439@excelforum-nospam.com...
>
> 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]

"m3s3lf" <m3s3lf.28hv0m_1148780401.439@excelforum-nospam.com> wrote in
message news:m3s3lf.28hv0m_1148780401.439@excelforum-nospam.com...
>
> 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

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