Conditional Formatting

  • Thread starter Thread starter Alex
  • Start date Start date
A

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.
 
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.
|
|
 
Back
Top