conditional format

  • Thread starter Thread starter Dibs
  • Start date Start date
D

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
 
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
 
excellent cheers

dibs
Earl Kiosterud said:
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
Click to expand...
 
Earl Kiosterud said:
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
Click to expand...

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,

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
-------------------------------------------
 
Back
Top