View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tywardreath Tywardreath is offline
external usenet poster
 
Posts: 5
Default Working with Dates

Hi

I'm trying to do some automation in Excel, and having no luck. I'd really
appreciate some help.

In cell A1 I have entered a date, and then the rest of the row has formulas
along the lines of A1+1, B1+1...

What I would like is the current today to be highlighted via conditional
formatting, and I'd like the spreadsheet to automatically open at the
current/today's date.

Any assistance gratefully received.

Cheers, Ty