Thread: Conditional Formatting Date
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default Conditional Formatting Date
Correction, line:
Formula is: =AND(F2<"",F2<TODAY())

should read:
Formula is: =AND(F2<0,F2<TODAY())
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote