Hi there

I would be grateful for some help with creating a formula please.  I’ve attached a screenshot below.

I have a spreadsheet where staff enter each new job as it comes into the office.  I want the cells in the Date Required column to automatically fill themselves as the staff member enters a date in the Date Received column.  The date to automatically fill should be 14 days after the date entered in the Date Received column.

THEN we would like to quickly see which jobs in the Date Required column are about to come due.  To do this we would like see the cell which is displaying a date within 2 days of todays date to turn red (background colour of the cell not the letters) unless the word ‘Completed’ is written in the Job Status column.  

I trust this makes sense and hope someone can help me. 

Thank you very much.

Kim

​Hi thereI would be grateful for some help with creating a formula please.  I’ve attached a screenshot below.I have a spreadsheet where staff enter each new job as it comes into the office.  I want the cells in the Date Required column to automatically fill themselves as the staff member enters a date in the Date Received column.  The date to automatically fill should be 14 days after the date entered in the Date Received column.THEN we would like to quickly see which jobs in the Date Required column are about to come due.  To do this we would like see the cell which is displaying a date within 2 days of todays date to turn red (background colour of the cell not the letters) unless the word ‘Completed’ is written in the Job Status column.  I trust this makes sense and hope someone can help me. Thank you very much.Kim        Read More

​