Try Conditional Formatting. Here are some site to learn
about it:

http://www.xldynamic.com/source/xld.CF.html
http://www.contextures.com/xlCondFormat01.html

HTH
Jason
Atlanta, GA

-----Original Message-----
I am trying to have things auto color-coded by date. For
example, if it is
0-10 days old it is GREEN, if it is 11-20 days old it
is YELLOW, and if it
is 21-31 days old it is RED. How can I set that up to
work????


Thanks,
Kamel



.