Here is my set up.

Colum E has the date a visit was done and column G is empty until a report is
handed in.

I would like column G to turn red when the report is not handed in within 15
days and to stay red when the date the report was finally put in to show that
it was late.

If there is a way to do this all your help would be mucha appreciated!!!

Thanks in advance