CONDITIONAL FORMATING DATES
 

How do I highlight a cell that has a date older than 7 days from todays date?
ex. column G has the date I passed out the invoice to be signed off on. I
want to highlight all those that have been out for more than 7 days.

I tried Formula is =G:G<TODAY()-7 but that highlights every date no matter
if it is older than 7 days or even future dates.

If I want it to look really nice I would like it to highlight the entire row
that date fall in.

Hi

Mark the whole range of data you want to format.
With the cursor in cell G1, FormatConditional FormattingFormula Is
=TODAY()-$G17
Select a format that you wish.

Regards

Roger Govier



tomklem wrote:

How do I highlight a cell that has a date older than 7 days from todays date?
ex. column G has the date I passed out the invoice to be signed off on. I
want to highlight all those that have been out for more than 7 days.

I tried Formula is =G:G<TODAY()-7 but that highlights every date no matter
if it is older than 7 days or even future dates.

If I want it to look really nice I would like it to highlight the entire row
that date fall in.

try
selecting all
conditional format
formula is =and($G1<today()-7,$G1 30000)



"tomklem" wrote:

How do I highlight a cell that has a date older than 7 days from todays date?
ex. column G has the date I passed out the invoice to be signed off on. I
want to highlight all those that have been out for more than 7 days.

I tried Formula is =G:G<TODAY()-7 but that highlights every date no matter
if it is older than 7 days or even future dates.

If I want it to look really nice I would like it to highlight the entire row
that date fall in.

Tom,

I'll presume that the dates are in column G, and the first is in G2 (Row 1
is probably headings). Select the range (row and column-wise). Press Tab
(or Shift-Tab or Enter or Shift-Enter) until the active (white) cell is G2.
Format - Conditional Formatting - Formula is:

=$G2<(TODAY()-7)

Set the format desired, and away you go.
--
Earl Kiosterud
www.smokeylake.com

"tomklem" wrote in message
...
How do I highlight a cell that has a date older than 7 days from todays
date?
ex. column G has the date I passed out the invoice to be signed off on. I
want to highlight all those that have been out for more than 7 days.

I tried Formula is =G:G<TODAY()-7 but that highlights every date no
matter
if it is older than 7 days or even future dates.

If I want it to look really nice I would like it to highlight the entire
row
that date fall in.