Conditional Formatting

[Alex]

How do I format a range of cells that contains a 3 digit
number no matter what order the numbers are in?

Example: in cells A1:A4 345,792,534,867
Then in cell B1 I post 354 I want to be able to
Conditionally format no matter what combination I choose.

 

[Pieter Kuyck]

Formula Is
=AND(ISNUMBER(A1),LEN(A1)=3)

Pieter


| How do I format a range of cells that contains a 3 digit
| number no matter what order the numbers are in?
|
| Example: in cells A1:A4 345,792,534,867
| Then in cell B1 I post 354 I want to be able to
| Conditionally format no matter what combination I choose.
|
|