View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gotroots Gotroots is offline
external usenet poster
 
Posts: 114
Default Can conditional formatting be used where .....

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.