We would like to monitor people who submit their timesheets late.

So when we put their names on the spreadsheet it automatically flags when it is late; i.e a number pops up on their name or the name automatically turns a colour.

have tried unsuccessfully to come up with a formula.

thank you
Anodiwa