Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting | Excel Worksheet Functions | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
enhanced conditional formatting | Excel Discussion (Misc queries) |