Excel Excel 'end of month' datedif and Conditional formatting

[jedwar]

Help please!

I've created a spreadsheet with a cell containing today's date.

I then have another cell where I want a 'use-by-date' of a product (mm/yyyy)

1. I want to conditionally format the 'use-by-date' cell to highlight in yellow when its within so many days from today's date?


2. If the product is used (the mm/yyyy deleted) the cell will highlight in red until a replacement product's 'use by date' is entered.


I appreciate excel may cause me a few problems recognising the end-of-month date and hence I understand the zero of the month trick but I'm really head scratching on how to incorporate this into an entire formula for the cell.

Can anyone offer help or advice?

Thank you in advance

 

[Sifou]

Hi,

Could you send me a dummy file so that I can try to understand further and find a proper fix to your issues ? my email: (e-mail address removed). Thanks