I have created a formula in column F to state 'Out of date' when the date in column D is less than 'todays' date in column F1. With help I have managed to highlight the row in red when this happens.

What I would like to happen is that 30 days before the expiry date the row highlights orange to prompt me to reorder the item. Then after the expiry date the row then turns red.

Any help would be amazing.

I have attached the document.

SundryTest.xlsx

Thanks.