In CF, you just need to return a True/False and you use the Format to set
the style. So your formula would be

=AND(condition1, condition2, condition3)

and then format for strikethrough.

One other issue is that with CF you cannot refer directly to other sheets,
so you need to create an Excel defined name (InsertNameDefine Name) for
any ranges on other sheets.

Your formula is syntactically incorrect, you MATCH a single value against a
list, not a list against a list. What is the logical requirement?



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Corey" wrote in message
...
I have 2 sheets i need to compare values with each other.
If there is a MATCH in value then i need the cell value to be changed to
Strikethrough.

There is 3 IF conditions though.

something like this:

=IF(AND(MATCH(SHEET8.D:D.VALUE =
SHEET4.A:A.VALUE),(MATCH(SHEET8.D:D.OFFSET(1,0).VA LUE =
SHEET4.A:A.OFFSET(2,2).VALUE),(MATCHSHEET8.D:D.OFF SET(2,-3).VALUE =

SHEET4.A:A.OFFSET(2,-1).VALUE),FONT.STRIKETHROUGH=TRUE,FONT.STRIKETHROU GH=FA
LSE)

Can/How would i go about that ?
Each D:D and A:A needs to be a cell value that matches another cell value
from across sheets.

Possible?

Corey....