Conditional Formatting Dates

[John]

I want to use conditional formatting to highlight cells in a column where
Today's date is greater than the cell value. What is the formula I would
use in the conditional formatting options?

 

[Bob Phillips]

=A1<TODAY()

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
something like
=TODAY()>A1
for cell A1

 

[John]

That didn't work. See my reply below.

=A1<TODAY()

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[John]

That didn't work.

Basically I have a column of due dates for projects, and I want to compare
that column with today's date. Any project with a date less than today's
date I want to change the cell color. So I am using conditional formatting.
I changed the test from cell value to formula, but I don't know the right
formula.

 

[Frank Kabel]

Hi
in which cells are your date values (exact cell references) and which cells
do you want to highlight

 

[John]

The dates are in cells G3 to G260. I want to highlight the cells that are
have a date that is less than today's date. This basically shows which
projects were scheduled to be done by now, but are not.

 

[Frank Kabel]

Hi
- select G3:G260
- goto the conditional format dialog and choose 'Formula is'
- enter
=G3<TODAY()
- choose your format

 

[John]

Ok, that seemed to work. Now I'd like to through a wrench in the whole
thing. I have some blank lines in that column. It is highlighting those as
being less than today(). How do I get around that?

 

[Bob Phillips]

=and(G3<>"",G3<TODAY())

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Daniel.M]

Hi,

=AND(G3<TODAY(),G3<>"")

Regards,

Daniel M.

 

[John]

Thanks for everyone's help. I appreciate it. Now I can create this report
and have that automated.