Find text in cell using cells object with-in IF Then statement

Im am trying to find particular text in a cell then format adjacent cells in the same row. In my code below I am trying to search for "*[Tx]*" using Like, however this is formatting all text that contain "T".

Any help much appreciated.

Please Login or Register  to view this content.

Try this:

Please Login or Register  to view this content.

Originally Posted by stnkynts

Try this:

Please Login or Register  to view this content.

Hi stnkynts,
Thanks for the code this works, could the last column used be include to replace EntireRow for the cell borders formatting, apologies I should have included this is my initial request?

Maybe this:

Please Login or Register  to view this content.

This would have been much easier had we had the workbook in the first place.

Please Login or Register  to view this content.

Many thanks this is exactly what im after.