VBA Help - Look in Column A, if cell contains "total" Then Function

[Johnny Thunder]

Hello Group,

I am working on a project and need some help.

I have a sheet that contains a pivot table Range A:Q and need code that will look in Column A for the string "Total" (will contain other text besides total) and then look in that specific Row columns F:Q and see if the cell is greater than or less than 50, if so, highlight the cell Yellow.

Any help is appreciated.

 

[fhqwgads]

i'm not sure how to do that with vba but maybe with conditional formatting try add this rule

=AND(ISNUMBER(SEARCH("Total",$A1)),A1>=50)

and apply it to the range =$A:$Q and pick a fill color to highlight it how you want

hope that works

EDIT: wait maybe just apply it to =$F:$Q