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)
.
|