Hi, Im new to this forum and rusty with Excel, but hope you can help.
I have a simple spreadsheet to record tasks in a log format. I have a date column A3 that shows the date a job is logged. I have a 'completed' column I3 that is blank until the completion date is entered. I want to be able to 'fill' the blank cells in the I3 column with colours representing the number of days after the date in column A3 as follows:
The default fill for an empty cell I3 should be light green/black text
If still blank 3 days after the date in A3, column I3 should change to orange.
If still blank 5+ days after the date in A3, colum I3 should change to red.
If a date is entered into I3 then the fill should return to the default (light green/black text).
The above will give a visual representation of jobs slightly or seriously overdue.
Hopefully the above makes sense however try as I have for two days I cannot get this to work.
Thanks in anticipation.
Bookmarks