Formating a row based on one cell's date

[Tee51]

Hello,

I'm working on a spreadsheet that has columns A - G. Column A has th
dates. I would like to create a format that will highlight the entir
row if column A has a date within the past 7 days. In my example for o
the rows should be highlighted. I was able to find formulas that onl
worked on one cell. Can someone help me with this? PLEASE & THANK YOU!


**Example**
7/17/12 DEA MA ACCT CONT Closed
7/13/12 HHI MA ACCT CONT Closed
7/10/12 MMG MA ACCT CONT Closed
7/16/12 ABC P ACCT CONT Closed
7/13/12 TAL W ACCT CONT Closed
7/20/12 HOK P ACCT CONT Close

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Spencer101]

Hello,

I'm working on a spreadsheet that has columns A - G. Column A has th
dates. I would like to create a format that will highlight the entir
row if column A has a date within the past 7 days. In my example for o
the rows should be highlighted. I was able to find formulas that onl
worked on one cell. Can someone help me with this? PLEASE & THANK YOU!


**Example**
7/17/12 DEA MA ACCT CONT Closed
7/13/12 HHI MA ACCT CONT Closed
7/10/12 MMG MA ACCT CONT Closed
7/16/12 ABC P ACCT CONT Closed
7/13/12 TAL W ACCT CONT Closed
7/20/12 HOK P ACCT CONT Closed

Hi,

Is this what you mean?

You use conditional formatting and lock the column using $ in th
formula.

Have a look at the conditional formatting rule to see what I mean

+-------------------------------------------------------------------
|Filename: Tee51 Example.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=471
+-------------------------------------------------------------------

 

[Tee51]

Just add another condition to the AND....

=AND($A1>=TODAY()-6,*$A1<=TODAY()*,$F1<>"Closed")

Thanks for your help

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Spencer101]

Thanks for your help!

Not a problem. Happy to help

+-------------------------------------------------------------------
+-------------------------------------------------------------------