I have a spreadsheet to record when monthly duty reports are received by each
employee and reviewed by mgmt.

Column A1:A200 Employee Name
Column B1:B200 Date Received in April
Column C1:C200 Date Reviewed in April
Column D1:D200 Date Received in May
Column E1:E200 Date Reviewed in May etc

Is there a formula I could use to fill the cell in grey when a report is not
received
when a report is received late in blue and when a report is received on time
in pink?

Reports received the 5th business day of the following month of the report
(i.e. april report due the 5th business day in may) are considered late and
reports reviewed after the 10th business day are late.

Any suggestions without using code?


Thanks!! :)