coloring entire row if specific cell have certain value

Hi friends need help

i have inserted table in worksheet through ribbbon
the table gets new ROW generated automatically on any value entered, table utilizes column A to K
so now coming to point
what i am trying to achieve is if user enters specific text in cell of column B like "Problematic" or "Set Hold" the entire table row should get colored with red color

Thanks in advance to all gurus

try the following macro:

Please Login or Register  to view this content.

Thanks for reply
i tried the code but Their is an ERROR ...Msg "Complie Error : Next without For" ......this is for the third Last row "Next icount"

actually i wanted to use it in USERFORM when the user select that specific text in listbox "Problematic" and create entry in worksheet that entire A:K row should be read..but was not able to do it
so I pasted it in Modules ..and their the ERROR "Complie Error : Next without For" occured

i wont be able to reply for the day ...tomorrow i will reply.

see amended code below:

Please Login or Register  to view this content.

You can add this to Worksheet_Change event to have it run every time the user amends any value. See attached:Book2.xlsm
HTH!

Still the same Error
"Complie Error : Next without For" occured

Mate, I do not see any error when I run it on my PC. Did you see the attached example? (re-attached here - Book2.xlsm ). There are two macro's in it.

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Please ensure that Macro is enabled. Or else, attach your workbook.

Hi,
May I request you to please mark this thread as "Closed". I'll see if I can be of any help with your other request.

Yes. (My bad - I should have said mark this thread as "Solved")