Conditional Format for Future Date

[Hartsop Dodd]

Hi all.

I am trying to find a formula for conditional formatting.
If the date in cell A1 is in the future, then the condition is true,
otherwise false.

Have tried:

=IF(A1>(TODAY),TRUE)

and all variations, does not work as required.
All cells in column A are formatted for Date.

Thanks for your time & help.

Hartsop

 

[A.W.J. Ales]

Hartsop,

Try (tested, works for me) :
Format /Conditonal formatting
Select Formula is and enter =A1>TODAY()

Select the formatsetting you want. OK

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Norman Harker]

Hi Hartsop!

Use:

=A1>TODAY()

Conditional format conditions can be tested as ordinary formulas. So I
can use the above in a cell and it returns TRUE

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi
in the conditional format dialog enter the formula
=A1>TODAY()

 

[Hartsop Dodd]

Hi All

Three identical answers just had to be right!

Many thanks.

Hartsop



*A.W.J. Ales* has posted this message:

 

[A.W.J. Ales]

YW Hartsop, it's always nice to hear that thinks work.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *