Help!
I am struggling with conditional formatting when attempting to change cell colours based on due dates, ie. change to yellow if due date is within 30 days, change to red if due date is overdue.
My efforts to date have been unsuccessful as the blank cells also change colour. I attach a screen shot of the conditional formatting I am attempting to advice you can offer would be gratefully received.
Thank you,
Stewart
Bookmarks