Thread: Changing the color of a cell in excel based on due date
View Single Post
  #1   Report Post  
MPatterson MPatterson is offline
Junior Member
  
Posts: 2
Exclamation Changing the color of a cell in excel based on due date
Hi,

I am working on a spreadsheet at the moment for my boss where I need to make the cell change color due to VISA's expiry dates

For example if a VISA is still valid the cell will be green
if the VISA is due to expire in 6 months the cell will be orange
if the VISA is due to expire in 3 months the cell will be red

I am working in Microsoft Excel 2010.

Help please!!!!
Reply With QuoteReply With Quote