Thread: How do I highlight today's date in a monthly schedule spreadsheet.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default How do I highlight today's date in a monthly schedule spreadsheet.
Highlight rows
CF
Formula is: =$a1=Today()

select colour

OK

"munch" wrote:

I'm using Excel for scheduling employees. The spreadsheet is set up for the
entire month with each day's date in column A. How do I create conditional
formatting to automatically highlight the row containing "today's" date?
Reply With QuoteReply With Quote