Autofill cell with color based on deadline

Closed
ROME - Jul 15, 2014 at 02:52 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 15, 2014 at 09:45 AM
Hello,

I would like to ask for help on a task I need to do dealing with dates and deadlines. I have "C" with the due date of the task and would like to have it reflect "Red" for "OVERDUE", "Green" for "ON TIME". I need this to be based on the current date of the system. How would I do this? I would really appreciate all the help!


3 replies

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jul 15, 2014 at 03:12 AM
what is definition of overdue and intime. does col. C contain words like "in time" or "over due" or does it contain only some dates.

post a very small extract of your data
0
"C" only contains dates. I'm sorry for confusing you. Let me correct this . . . If date on "C" has passed today's date then I want it reflect red. It should reflect Green if today's date is not over the DUE ON ("C") column. I hope that helps.
0
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jul 15, 2014 at 09:45 AM
firsts remove all the colors
2. loop through c column from C2 down
3
for each c in range(range("C2"),range("C2").end(xldown))      'c1 is heading
if c>=date then
c.interior.colorindex=3
else
c.interior.colorindex=4
next c
0