coloring issue
 

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

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



.

Try this:
Insert a column (Example: Column A) and have it autopopulate with today's
date by entering =now() into the cell.

Then go to Format/Conditional Formatting. In Condition 1, Use 'cell value
is' and select 'between' for the next value. The dialog box will give you
two fields to the right. Enter the field with today's date (Example: =A1) in
the first box, then enter the field with today's date less 10 in the far
right box (Example: =A1-10). Click on the format button and turn green
(either via font or fill).

Click on the 'Add' button at the bottom of the dialog box. For Condition 2,
use 'cell value is' and select 'between' for the next value. The dialog box
will give you two fields to the right. Enter the field with today's date
less 11 (Example: =A1-11) in the first box, then enter the field with today's
date less 20 in the far right box (Example: =A1-20). Click on the format
button and turn yellow (either via font or fill).

Click on the 'Add' button one last time. For Condition 3, use 'cell value
is' and select 'less than or equal to' for the next value. Enter the field
with today's date less 20 (Example: =A1-20) in the dialog box. Click on the
format button and turn red (either via font or fill).

Click 'OK' at the bottom of the dialoq box.

Finally, to clean up your sheet right click on the column with today's date
(Example: A) and select 'Hide'. Your sheet will now auto format dates with
the appropriate color.

"TheKamel" wrote:

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