Create a Macro to turn a range of cells (a row) yellow if the word "Total%" is in cell Bx

I am wanting to have a macro run after refresh is done on the spread sheet.

The key is in Column 'B' search for the rows that have the text 'Total' (number follows the text)
and turn that row and column A through K Yellow
and make the cells height 31 pixels (instead of the 25 like the others)

Under Format on the menu go down to conditional formatting and select this; Cell value is > go over to the next column hit the drop down arrow and select is equal to Total in the third box. Then select Format, border select yellow and apply. Hope this helps!

I see how the conditional formmatting works but it only highlights the cell that has the text 'Total'

I need it to highlight the rows A - K which have the total numbers too - but only the rows where the text 'Total' is.

Include a example of your workbook, so we can follow the progression you would like.

here is what I mean by the Total row A-K getting highlighted.

Please Login or Register  to view this content.

You can give this a try.

No problem Winon just trying to help. I am always learn too.

LeapingLizard

What did you do to the sheet?