Excel Excel 'end of month' datedif and Conditional formatting

Joined
Jun 12, 2011
Messages
1
Reaction score
0
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. :confused:

Can anyone offer help or advice?

Thank you in advance :-)
 
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
 
Back
Top