Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight current date
I have a shared workbook that we schedule on, it has a 6 week set up from
week beginning Sat and Ending on Friday. Multiple people use this workbook. The dates recycle, When we reach the end of the 6 weeks, we clear the schedule and redo the dates for the next 6 weeks. My question is this. Each week has a series of zipcodes associate with it, that is how we choose to schedule things. If when we use the find function to look for the zip code, it will pick up the first one it finds, what we'd like it to do, is to go to zip code in the current week. How to I convince it to go to the current week? -- NealMed |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight current date
Consider using a helper column with something like:
=zipcode & date When you do a find, it will pick the correct one. -- Gary''s Student - gsnu200731 "NealMed" wrote: I have a shared workbook that we schedule on, it has a 6 week set up from week beginning Sat and Ending on Friday. Multiple people use this workbook. The dates recycle, When we reach the end of the 6 weeks, we clear the schedule and redo the dates for the next 6 weeks. My question is this. Each week has a series of zipcodes associate with it, that is how we choose to schedule things. If when we use the find function to look for the zip code, it will pick up the first one it finds, what we'd like it to do, is to go to zip code in the current week. How to I convince it to go to the current week? -- NealMed |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight current date
Or consider organizing the wroksheet in a way you shouldn't have to use find.
For example, a table column for date and a table column for zip. Filter for date and filter for zip. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to highlight current row & column automatically by a color | Excel Discussion (Misc queries) | |||
highlight current row/column | Excel Discussion (Misc queries) | |||
calendar highlight current date | Excel Discussion (Misc queries) | |||
how do I highlight the current row and column | Excel Discussion (Misc queries) | |||
how to highlight current row & column automatically by a color | Excel Discussion (Misc queries) |