Hi Charlize-
That was it- Thanks! I should have tried just dimming it like the message box had notified me....
Your solution took care of another issue where I am looking for a variation of the original term-!

Thanks to you and Tommy I have a nice working little procedure!
[VBA]
For i = 1 To Lrow
For Each Item In Array("HAT", "FTWR", "BOOT", "BOOTW", "BOOTY")
If Cells(i, "F") = Item Or Cells(i, "G") = Item And _
Cells(i, "M").NumberFormat = "0.000" Then
Cells(i, "M").Interior.ColorIndex = 6 'search for PatternColorIndex
Cells(i, "M").NumberFormat = "# ?/?" '10.75 displays as 10 3/4
Exit For
End If
Next Item
Next i
[/VBA]