hey everyone 
i'm using this code below to color sheet tab if string "9.9999" found in column "A" on an excel sheet.
Dim ws As Worksheet
Dim wb As Workbook
FoulTime = "99999"
Dim rng As Range
Set wb = ThisWorkbook
For Each ws In wb.Worksheets
ws.Columns("a:a").AutoFit
Set rng = ws.UsedRange.Find(FoulTime)
If rng Is Nothing Then
ws.Tab.ColorIndex = 4
Else
ws.Tab.ColorIndex = 3
End If
Next ws
recap: if "9.9999"found Color Tab = Red, if not Green.
The problem is what if wanted the Color to become red if both strings "9.9999" OR/AND "0.0000" found?
how do i do ?
thanks in advance
regards
Bookmarks