Conditional Formatting
 

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)

Hi

select the cells
choose format / conditional formatting
choose
cell value is
choose
less than
type
=today()
click the format button - set your format
OK twice

Cheers
julieD

"Joooooooo" wrote in 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)