Hi new and been dealt a task by husband I am struggling with.
I have a spreadsheet (attached) and the dates in column B are dates due (these may change - this is just a template) I think I have set a format to change colour when they are due and + 7 days due. When the date in column C is inputted, if it is the same as the due date I want both B and C columns to be white, if C is later than the due date, I want it to be red.
Can this be done?
Feeling thick!
Thanks
Kate Attachment 244852
Bookmarks