Hello - I am new to google groups and coding with VBA. I'm hoping
someone can assist with my problem. I think it is kinda easy, I have a
pivot table and within column A there is a entry that contains the word
'total', created by the pivot when creating. What I'm looking to do is
hight light this row IF the corisponding cell in column F is a negative
number. But if the word TOTAL is found and the number in colmun F is
positive then, do nothing. I think this might be done via condional
formatting as well but not sure of the syntax.