Excel 2003 formula

[Ginger]

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

 

[tompl]

If you are familiar with conditional formatting you could apply conditional
formatting using a formula similar to this:
“=IF(VLOOKUP(A1,'Sheet 2'!A:B,2,FALSE)="yes",TRUE,FALSE)
where A1 is the cell being formatted. Then choose the strikethrough format
for when the condition is true.

Tom

 

[Ginger]

Thanks but still not working. Excel takes the conditional formula but the
sheet isn't changing. I tried both formulas with the same results. Any other
suggestions? I could email it to one of you?

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

 

[Don Guillett]

CF does not like other sheet references but you can fool it by simply
defining a name on the words sheet lookupwords= $a1:$b$18 or make it dynamic
by using this formula to define the name
=offset($a$1,0,0,counta($a:$a),2)

then use this in the players sheet for your CF
=VLOOKUP(E2,lookupwords,2,0)="yes"
and format as desired in black or strike