Hi,I am working with Excel 2003 and would liek to automate cell shading.my criteria is text based and ther are 8 permitations so conditional formatting is out of the question.utilising VB i have managed ot gt teh cells to colour as required when i populate with the the relevant info using the...