Conditional Formatting

[Alex]

Example: in cell A1 345 cell A2 543
Then in cell B1 I post 354 I want to be able to
conditionally format cell A1 and A2 no matter what
combination I choose weather it be 354, 345, 435, 453,
534 and

 

[Pieter Kuyck]

Alex,

Maybe this is what you want, in conditionally formatting - Formula Is

=AND(SUM(FIND(MID("345",ROW(INDIRECT("1:3")),1),A1))=6,LEN(A1)=3)
The value in A1 may exists of a combination of the numbers 3,4 and 5. So 334 will give false.


When the numbers are variable then this formula will work. In cell A1 the numbers to test, in cell B1 and further this
conditional formatting

=AND(SUM(FIND(MID($A$1,ROW(INDIRECT("1:"&LEN($A$1))),1),B1))=SUM(ROW(INDIRECT("1:"&LEN($A$1)))),LEN(B1)=LEN($A$1))

Pieter

| Example: in cell A1 345 cell A2 543
| Then in cell B1 I post 354 I want to be able to
| conditionally format cell A1 and A2 no matter what
| combination I choose weather it be 354, 345, 435, 453,
| 534 and
|

 

[David McRitchie]

Hi Alex,
I did not understand your question when you posted it yesterday
but you did get an answer from Peter Kuyck and it is probably
what you are looking for, if not you should continue there rather
than posting/posting/posting in additonal threads. Peter's answer at
http://google.com/[email protected]

--