View Single Post
  #2   Report Post  
Lee
 
Posts: n/a
Default

Under conditional formatting select "Formula Is" and enter
this: =A1<(ROUND((NOW()),0))
where A1 is the cell with the date in it.

Lee
-----Original Message-----
How do I conditionally format some cells so that the ones

containing a date
that comes before today are highlighted? I've tried

everything I can think
of! (Mind you, that's not much)
.