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
Microsoft MVP Excel
SalesAid Software

"Ginger" wrote in message
...
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?


"David Biddulph" wrote:

You don't need IF(...,TRUE,FALSE)
The formula =(VLOOKUP(A1,'Sheet 2'!A:B,2,FALSE)="yes" will already return
the Boolean values TRUE or FALSE, so your IF function adds nothing.
--
David Biddulph


"tompl" wrote in message
...
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


.