| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight a Date Range
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Highlight a Date Range
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Highlight a Date Range
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" 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 -- m3s3lf ------------------------------------------------------------------------ m3s3lf's Profile: http://www.excelforum.com/member.php...o&userid=34874 View this thread: http://www.excelforum.com/showthread...hreadid=546223 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Highlight a Date Range
"m3s3lf" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Highlight a Date Range
Bob Phillips Wrote: "m3s3lf" wrote in message ... 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 -- m3s3lf ------------------------------------------------------------------------ m3s3lf's Profile: http://www.excelforum.com/member.php...o&userid=34874 View this thread: http://www.excelforum.com/showthread...hreadid=546223 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| highlight a date | Excel Discussion (Misc queries) | |||
| Macro to Highlight Range | Excel Discussion (Misc queries) | |||
| code to highlight max value in a range | Excel Programming | |||
| Highlight active range? | Excel Programming | |||
| highlight of a range | Excel Programming | |||
Hybrid Mode
