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!