View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomPl TomPl is offline
external usenet poster
 
Posts: 342
Default Excel 2003 formula

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