View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Conditional Formatting on 'Today'

See http://www.xldynamic.com/source/xld.CF.html#due

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Madame Artois" wrote in message
...
I want to set up a conditional format in an Excel spreadsheet using the
Today
function. If the date in the cell is greater than TODAY leave it but if
the
date is less than today highlight the cell.

Has anyone got a clue on the conditional formatting?
--
Confused but battling on