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


.