Conditional Formatting

J

Joooooooo

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

Lee

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

Lee
 
Top