If you have a date to compare to on the row then you would compare
that date you would use $ sign in front of the column so you can make
it apply to the entire row.
=TODAY()$A1+7
or for within current week (or later) beginning on a Sunday
=$A1(TODAY()-WEEKDAY(TODAY()))
to restrict past and future dates to the current week beginning on a Sunday
=AND($A1(TODAY()-WEEKDAY(TODAY())),$A1<=(TODAY()+7-WEEKDAY(TODAY())))

Or maybe you want to use a filter to show only those rows.
http://www.contextures.com/tiptech.html
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"DTTODGG" wrote in message ...
OK, I'm back. Still learning about cell colors.

I have a report that I'm updating every week. It's cummulative, but the boss
only wants to see what has changed. So, I have "highlighted" this weeks
changes.

But, next week, I would like to revert all the "highlighted" cells back to
"no fill" color and "highlight" this weeks new changes.

I can always pick the same color "highlight" if that makes it easy (find all
the cells in yellow and change to no fill).

Thank you so much for all of your help.

"DTTODGG" wrote:

David,

Thanks for the URL. Great examples, I'll have to read through them - lots to
learn!
JLR

"David McRitchie" wrote:

What you are describing is available with Conditional Formatting
Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"DTTODGG" wrote in message ...
Hello -

I'm wondering if there is anyway to control cell color based on a condition?

If a cell is not empty - color = red
If the date is older than last week - color = blue
If an IF statement is true, then color otherwise don't

Thank you!