View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Corey Corey is offline
external usenet poster
 
Posts: 363
Default Conditional Formatting across Sheets

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=FALSE)

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....