Excel: Strikethrough Range When Column Cells Contain Certain Values
Posted on 2011-10-29
In range $B$26:$N$45, column E contains strings of the following format: 7,12,7,5,7,8. In range $J$13:$L$18 each row contains single non-repeating integers (3, 11, 7). I need a VBA routine to check if column E of the first range contains integers from each row of the second range according to the following rules:
* First value of first range must match one of cells in first row of second range;
* Second value of first range must match one of cells in second row of second range;
* Sixth value of first range must match one of cells in sixth row of second range;
All rules are ANDed and if a row in the first range does not meet the strictures of the above rules then both italics and strikethrough are applied to that row!