G
Gotroots
Can conditional formatting be used where text is included with numbers.
Let me explain by example.
A1 = flex 358
A2 = B, 358
A3 = R-U, 354
When A2:A3 numbers do not corresponds to A1 number then highlight cell.
Therefore A3 in this example should be highlighted.
A1:A3 quantities are the result of a formula.
Let me explain by example.
A1 = flex 358
A2 = B, 358
A3 = R-U, 354
When A2:A3 numbers do not corresponds to A1 number then highlight cell.
Therefore A3 in this example should be highlighted.
A1:A3 quantities are the result of a formula.