color formula

[wd8ekd]

Trying to figure out the formula to color only the
Double numbers that are in this group.ROWS-A-B-C-D
Any idea’s?????
We want to color the all double numbers Red.


029--295--095--025
169--690--190--160
280--802--202--282
360--602--302--362
456--564--464--454
594--940--540--590
613--134--634--614
759--592--792--752
828--289--889--829
951--510--910--950


Thanks Bob

[NBVC]

What do you mean by double numbers?.. I don't see any duplicates in your sample set.

[arthurbr]

And ABCD are columns I suppose?

[wd8ekd]

Sorry about that . What I meant was double numbers like
464 454 889 ----want them in red....only the double numbers
hope I explained it right..
Thanks
Bob

[NBVC]

Select the range and go to Format|Conditional Formatting

Select Formula Is from 1st drop down menu and enter this formula:

=OR(LEFT(A1)=MID(A1,2,1),LEFT(A1)=MID(A1,3,1),MID(A1,2,1)=MID(A1,3,1))

where A1 is your top-left most cell in your selection

Click Format and choose your colour.

[wd8ekd]

WORKS EXCELLENT!!!
Thank you
Bob