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
Bookmarks