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.

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.