Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Muti-page workbook highlight specific dates that occur throughout
I'm working on a muti-page workbook and want to highlight specific dates that
may occur throughout the workbook. I want to be able to type in the date and it automatically highlight that date if it occurs anywhere in the entire workbook. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Muti-page workbook highlight specific dates that occur throughout
If I understand what you want correctly, you can do that by using the
Edit/Find option in Excel's menu bar. Click Edit/Find, click the Options button so you can see all the possible selection options available, select Workbook from the Within field and type your date into the "Find what:" field, then click the "Find All" button. In the list that appears, click on each different Sheet (only once per sheet is required) and press Ctrl+A. Once you have done that (once) for each sheet, click Close. All cells containing the date you searched for will be highlighted on each sheet. Rick "hamilton_heff" wrote in message ... I'm working on a muti-page workbook and want to highlight specific dates that may occur throughout the workbook. I want to be able to type in the date and it automatically highlight that date if it occurs anywhere in the entire workbook. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking to a specific page in an excel workbook | Excel Discussion (Misc queries) | |||
External hyperlink to a specific page in a workbook | Excel Worksheet Functions | |||
Please help - Looking for a way to sum up for specific error codes that occur in multiple months. | Excel Discussion (Misc queries) | |||
counting occasions dates occur between 2 dates | New Users to Excel | |||
Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions |