change the formula in the CF to...
=AND($F2<>"",$F2<TODAY())
=now() includes time as well as date
edit: and for future reference, dont use "" around your formula....
="$F2 < now()"
change the formula in the CF to...
=AND($F2<>"",$F2<TODAY())
=now() includes time as well as date
edit: and for future reference, dont use "" around your formula....
="$F2 < now()"
Last edited by FDibbins; 01-29-2013 at 07:02 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks