I am using Excel 2010 pack. I have difficulties in creating the formula for my worksheet.
I want to know if we're given the date of issuance and it's expiry date, how to make a formula which will indicate how many days left before it get expire plus with the warning? How to make the expiry date column auto remind example in color? Let's say if it's about to be expiry in 10 days the column shall turn to red.
Above is the example how I want it to be formulated: