Hello, helpful people. I'm working in Google Sheets and I'd like to achieve the following: If G date is blank, show text "In Progress" in H If G date is before F date, show text "Complete" in H If G date is blank and F date has passed, show text "Overdue" in H If G date has passed F date, show text "Late" in H In case it matters: I've used the following formula to fill each row in amber/green/red/green for in progress/complete/overdue/late respectively: =$H$1:$H$999="Complete" Column H (Status) is using data validation for 'in progress'/'complete'/'overdue'/'late' I have alternating colours on (grey/white, as shown in the screenshot) Thanks ?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Due & Completion Dates / Status

Hello, helpful people.

I'm working in Google Sheets and I'd like to achieve the following:

In case it matters:

I've used the following formula to fill each row in amber/green/red/green for in progress/complete/overdue/late respectively: =$H$1:$H$999="Complete"
Column H (Status) is using data validation for 'in progress'/'complete'/'overdue'/'late'
I have alternating colours on (grey/white, as shown in the screenshot)

Thanks ?