Have a look at Conditional Formatting in Help, its all there and it will do
that with no problems,
Regards,
Alan.
"Luke" wrote in message
...
I need to have dates that have past show in red on my spread sheet. Can I
do
that with an IF statement?