Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
Conditional Formating & Rand() function | Excel Discussion (Misc queries) | |||
conditional formating using cells containg dates | Excel Discussion (Misc queries) | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |