Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Conditional formatting of date-cell - 2007 5
Date Calculation & Conditional Formatting 3
Excel Excel Conditional Format 2
conditional formatting date and blank cell 3
Conditional Formatting Applied when Statement Not True 6
macro for displaying conditional formatting 1
[Flashing] RED before renewal date 1

Back
Top