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