Change cell color if date is today or past

August 11, 2011 at 12:22:45
Specs: Windows 7
I need to change a cells fill if the date is in the past or today. Also change it to another fill if the date is within 1 month.
ie: date in column C is prior to today, fill red.
date is within 1 month, fill yellow.

See More: Change cell color if date is today or past

Report •


#1
August 11, 2011 at 12:25:11
Need to clarify, the dates in column C will be in the future, expiration dates. If todays date is within one monthm fill yellow. If todays date equals the date in that column or is in the past, fill red.

Report •

#2
August 12, 2011 at 15:31:41

Report •
Related Solutions


Ask Question