VBA to color Excel Tabs based on criteria in a Column

Hello. I am on the novice side of novice when it comes to VBA. I believe my issue is simple, but I stumped.

1) I have an Excel workbook with a 'Summary' tab (unique layout) and multiple 'other' tabs containing the same layout. In each 'other' Tab, in Column T2:T15, I have a formula that creates an "x" whenever a criteria is met.
2) My goal is to create a MACRO that colors a worksheet TAB "Red" if an "x" is listed on that worksheet anywhere in "T2:T12".

Here is what I currently have.. I get Syntax Error

'Color Tabs Red if JON not created
For Each sht In ThisWorkbook.Worksheets
If Format(sht.Range(T2:T15) = "x") Then
sht.Tab.ColorIndex = 255 'RED
End If
Next


Thanks in advance!!!

Please Login or Register  to view this content.

Originally Posted by ChrisRice

Excellent. Thank you. I was not sure what the 'Dim sht As Worksheet' was for. I removed that line it it worked great. Thanks again!!

You're welcome.

The Dim line declares the variable sht as a worksheet-type variable. It's better if it is included, but it is not required in this case.