Hi


A combined effort from JR@SGC and Chappo

1. Create a list of the sheet names

2. select the cell you want to conditional format (B2) then

3. Format > Conditional formtting...

4. when it opens change 'cell vaule is' to 'formula is' (via the drop down box)

5. enter the formula:

=IF(OR(B2=H21,B2=H22,B2=H23,B2=H24),TRUE,FALSE)

or

=If(or(B2=H21,h22,h23,h24,),true,false)

(H21 etc is our range and repeat for as many names)

6. then set your conditional formatting


Hope it works