Hi guys

I'm after some help with highlighting dates in excel 2013.

I'm currently working on a matrix that entails review dates. I'm attempting to get the dates to highlight yellow if they are due within the month and then turn red if they are over due. (In the same column)

I have tried various help guides online but they don't seem to do exactly what I want them to do. The conditional date formatting (pre-set) works for dates expiring within the month but there is no provision for expired (only lasts for 30 days after the date and then reverts back to white).

Any help would be greatly appreciated (sorry for the noob question)

Regards,

Matt


Sent from my iPad using Tapatalk