That is what conditional format is there for? Why not use it?

--
HTH

Kassie

Replace xxx with hotmail


"driller" wrote:

Hello,

without the use of conditional formatting, is it possible to format the date
turn red font if it is before today().

same like when numbers are treated as negative.

something like...
[red if < today()] dd-mmm-yy

regards,