Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
tomklem
 
Posts: n/a
Default 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   Report Post  
Roger Govier
 
Posts: n/a
Default

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   Report Post  
bj
 
Posts: n/a
Default

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   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP & Conditional Formating Help. Excel'ed Failures Excel Discussion (Misc queries) 6 August 16th 05 04:46 PM
Conditional Formating & Rand() function BaldySlaphead Excel Discussion (Misc queries) 10 July 20th 05 03:43 PM
conditional formating using cells containg dates Roy Excel Discussion (Misc queries) 2 May 24th 05 09:52 PM
more than 3 conditional formating in excel Manan Excel Discussion (Misc queries) 2 February 7th 05 10:12 PM
Formating Dates for production schedule dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 09:43 PM


All times are GMT +1. The time now is 06:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"