problem coloring sheet tab based on a condition

hey everyone

i'm using this code below to color sheet tab if string "9.9999" found in column "A" on an excel sheet.

Please Login or Register  to view this content.

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

Hello mehdoush,

You need to add another IF statement. This also checks if the cell is an empty string. The empty string is often considered to be a zero value.

Please Login or Register  to view this content.

Leith, sorry it didn't work properly

i already defined a range

Please Login or Register  to view this content.

can i add this string "0.0000" to the range ?

regards