1. Select the cell/Range (A2:A3). Please note that the cell reference A2
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula

=ISNUMBER(SEARCH(MID(A2,FIND(" ",A2)+1,99),$A$1))=FALSE

OR try the below formula if the above does not work

=ISNUMBER(SEARCH(MID(A2,MATCH(TRUE,ISNUMBER(VALUE( MID(A2,
ROW($1:$255),1))),0),SUM(--(ISNUMBER(VALUE(MID(A2,
ROW($1:$255),1)))))),$A$1))=FALSE


4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

PS: If you are using XL2007 Goto Home tabStylesConditional
FormattingManage rulesNew ruleUse a formula to determine which cells to
format. Enter the formula in the box below.


--
Jacob


"Gotroots" wrote:

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.