conditional format

[Dibs]

Hi
I'm trying to conditional format dates so that if the date displayed exceeds
6 months the cell turns red.

Any ideas please.

Dibs

 

[Earl Kiosterud]

Dibs,

If you mean turn red if the date is more than 6 months from the present
date:

Formula is: =A2> DATE(YEAR(TODAY()),MONTH(TODAY())+6,DAY(TODAY()))

Change the A2 to the cell that's selected, or if more than one is selected,
the active (white) cell.

Earl Kiosterud
mvpearl omitthisword at verizon period net

 

[Dibs]

excellent cheers

dibs

Dibs,

If you mean turn red if the date is more than 6 months from the present
date:

Formula is: =A2> DATE(YEAR(TODAY()),MONTH(TODAY())+6,DAY(TODAY()))

Change the A2 to the cell that's selected, or if more than one is selected,
the active (white) cell.

Earl Kiosterud
mvpearl omitthisword at verizon period net

 

[Dibs]

cannot get that to work for some reason, thanks anyway

 

[dvt]

cannot get that to work for some reason, thanks anyway

Dibs,

What happens when you enter Earl's formula? What doesn't work?

Dave
dvt at psu dot edu

 

[Israel Rodriguez]

Dibs,

If you mean turn red if the date is more than 6 months from the present
date:

Formula is: =A2> DATE(YEAR(TODAY()),MONTH(TODAY())+6,DAY(TODAY()))

Change the A2 to the cell that's selected, or if more than one is selected,
the active (white) cell.

Earl Kiosterud
mvpearl omitthisword at verizon period net

That looks like something I'm trying to do, except that I'm trying to set it
up where that's a due date which turns red because another cell doesn't have
an entry by the due date aka it's overdue.

 

[Dibs]

i sussed it thanks it was A2< and -6, not +6

Dibs

 

[Dibs]

is there somewhere people get all of these formulas or are they just Wizzes.

Dibs

 

[Earl Kiosterud]

Dibs,

We make 'em up. They ought to work somewhere in the universe, even if just
by chance.

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------