Conditional Formatting on 'Today'

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

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" <MadameArtois@discussions.microsoft.com> wrote in message
news:2C5A6FF2-E33F-4F72-B223-DED5CD091989@microsoft.com...
>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