Conditional Formatting on 'Today'

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Madame Artois - 20 Jun 2007 14:58 GMT

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?

Signature

Confused but battling on

Reply to this Message

Bob Phillips - 20 Jun 2007 17:19 GMT

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

Signature

---
HTH

Bob

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

>I want to set up a conditional format in an Excel spreadsheet using the
>Today
[quoted text clipped - 3 lines]
>
> Has anyone got a clue on the conditional formatting?

Reply to this Message