You could, for example, use CF/ Formula is:
=RIGHT(A2,LEN(A2)-FIND(" ",A2))<RIGHT(A$1,LEN(A$1)-FIND(" ",A$1))
--
David Biddulph

"Gotroots" wrote in message
...
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.