CONDITIONAL FORMATING DATES

T

tomklem

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.
 
R

Roger Govier

Hi

Mark the whole range of data you want to format.
With the cursor in cell G1, Format>Conditional Formatting>Formula Is
=TODAY()-$G1>7
Select a format that you wish.

Regards

Roger Govier
 
E

Earl Kiosterud

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