I am trying to conditionally format a column of cells based upon multiple conditions and also the value in the cell to the left of it. I originally used conditional format in the sheet, but it bloated the size of the workbook to over 10 Mb. I have started a workseet change event and this is what I have at the moment. It successfully changes the color of the cell based on the values from Sheet1, but not on the cell to it's immediate left.

Test Sheet.xlsThis is the part that I am struggling with. i is equal to the row number e.g. G3:G30

I have also uploaded a workbook which shows what I mean.

Thank you for any help you can give.

Please Login or Register  to view this content.
Here's the full code.

Please Login or Register  to view this content.
This question is also posted here http://www.ozgrid.com/forum/showthread.php?t=169305 but I have been unsuccessful in solving it so far.