Hi,
I have a spreadsheet with columns G-J setup with conditional formatting based on dates. the cell will change to yellow if the expiration is 60 days out, and will turn red if the expiration date is 30 days or less. I would like to setup a vba code that will give me a pop-up message upon opening the spreadsheet that will identify if a cell has turned red
For example " Cell __ will expire in 30 days."
I have a spreadsheet with columns G-J setup with conditional formatting based on dates. the cell will change to yellow if the expiration is 60 days out, and will turn red if the expiration date is 30 days or less. I would like to setup a vba code that will give me a pop-up message upon opening the spreadsheet that will identify if a cell has turned red
For example " Cell __ will expire in 30 days."