Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Network issue | Excel Discussion (Misc queries) | |||
Issue with copying Text. | Excel Discussion (Misc queries) | |||
Autofill issue... | Excel Discussion (Misc queries) |