I'm trying to make a formula for a list to check and strike out another on 3
sheets. Only 2 are using the info, sheet 3 has various colums to check.

Sheet 2
A B
dog yes
cat (blank)

Sheet 3
A C E etc...
Dog(striked) Blank Dog(striked)

If sheet 2, B is yes then check Sheet 3 colums and strike them out or change
color. Hope
that made sense. Similar to a called off list.

Please help me if you can.
TIA
Ginger