I have a worksheet that returns several hundred lines of data. I need code that will look at the first two characters of each row in column C and if the criteria is met colour the cell background of the whole row. Normally I would use conditional formatting e.g =LEFT($C$2,2)="AA" however I have more than 3 criteria and colour requirments. The number of rows in the worksheet are variable and colums are fixed. Thank you.