Hi Danny,

Am Fri, 5 Apr 2013 12:28:31 +0000 schrieb DannyQuinn:

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)

select F1:Fx and choose fill color red. Then with selection
=Conditional Formatting = Formula:
=G1="a" and format with green fill color.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2