|
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 05:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com