Autofill cell with color based on deadline
Closed
ROME
-
Jul 15, 2014 at 02:52 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 15, 2014 at 09:45 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 15, 2014 at 09:45 AM
Related:
- Autofill cell with color based on deadline
- Rj45 color - Guide
- Notepad++ change background color - Guide
- Powertoys color picker - Download - Other
- What color is audio out on pc - Guide
- Excel macro to create new sheet based on value in cells - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 15, 2014 at 03:12 AM
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
post a very small extract of your data
"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.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 15, 2014 at 09:45 AM
Jul 15, 2014 at 09:45 AM
firsts remove all the colors
2. loop through c column from C2 down
3
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
