Hi

I'm currently working on a spreadsheet that tracks paperwork for people that my organisation has moved into employment. I'm looking to colour code the dates where the paperwork has been due and not submitted.

The layout is as follows:

Column A: Reference number
Column B: Name of the client.
Column C: Employer
Column D: Date the said client commences employment.
Column E: Paperwork submitted (ticked where applicable)
Column F: Initial Sustained paperwork.
Column G: Paperwork Submitted. (Ticked where applicable)
Column H: Secondary Sustained Paperwork
Column I: Paperwork submitted (Ticked where applicable).

So As an example I would have:

T567-John Smith-ASDA-1/1/13-(tick)-1/2/13-(no tick)-1/3/13-(no tick)

What I'm looking to do is essentially flag up which dates have been overlooked or have outstanding paperwork.

So if cell G1 is blank then I would like cell F1 to turn red.
If I was then to insert a tick (in the form of the letter 'a' in Marlett font) then the cell F1 would turn green.

Please let me know if there is any way to do this or ask for clarification if I've not explained this very well.

