Help on getting cell background color to gradually change as it gets closer to the expire date
basically
1. Cell C25 looks at the current date
2. Cell C25 only shows the expire date
3. Cell C25 gradually changes background color from like:
light green to plenty of days left
light yellow days are about 1/2 gone
light red days are expired.
thanks for the help on this
basically
1. Cell C25 looks at the current date
2. Cell C25 only shows the expire date
3. Cell C25 gradually changes background color from like:
light green to plenty of days left
light yellow days are about 1/2 gone
light red days are expired.
thanks for the help on this