Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color Code Date Checking
Hi all, I found somewhat of a resolution via searching the internet prior to deployment but can't find it. So I decided to find out if you all can help me. I didn't know what to title this issue. This is what I want to do. In Column B I have a date. In column D, E, F, and G I have a check mark and the box is filled-in w/ a color. Anyways, here is what I like to do. In columns D-G...the title for each column is the following: D = 1 Week E = 1 Week < 1 Month F = 1 Month < 3 Months G = 3 Months What I want to do is have each block check the date in column B. If the date is within 1 week of today's date, I want the block in column D to be color filled w/ Green. If the date is greater than 1 week but less than 1 month I want the block in column E color filled w/ Yellow. If the date is greater than 1 month but less than 3 months I want the block in column F color filled w/ Red. If the date is greater than 3 months I want the block in column G color filled w/ Red. How can this be done. Sounds simple but I have no clue where to start. Thanks in advance for your help. Jason -- drvortex ------------------------------------------------------------------------ drvortex's Profile: http://www.excelforum.com/member.php...o&userid=15896 View this thread: http://www.excelforum.com/showthread...hreadid=507115 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions | |||
Date Math Problem | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |