I need cells to change colors based on the date that the license will expire. I am using excel 2010.
Example:
I want the cell to turn red if the license has already expired.
Yellow if the license will expire in 30 days or less,
and green if it is 60 to 30 days until expiration.
Note that the date of the expiration will be in the cell.
My name should give you an idea where I am with this. Any help is greatly appreciated.![]()
Bookmarks