hi guys!
I need some help.
I'm creating a spreadsheet to show when car MOT expires.
I have a column (F) which has MOT expiry dates in.
I have a CF which highlights the cell red if the date is more than TODAY. This worked fine.
What I would like is, once the MOT expiry date gets within 15 days before todays today, i want it go to orange.
thanks.