Hi folks, I'm looking for some help with a bit of VBA code that will do the following:

IF

* any cell in column C contains the word "Total" within other text in the same cell

AND

* For any cells on the same row as those containing the word "Total" in Column C, that are in Columns G to S and do not equal zero

Then

* highlight those cells in green

Can anybody assist?

I'm chasing my tail trying to do it with conditional formatting. I got it to work with conditional formatting on a little bit of sample data, but when I applied the exact same formatting to the dataset I want to use it for, it just doesn't work. So I'm thinking a bit of code is probably the way forward for me with this.

Regards