Conditional Formating by truncated values....
 

I wish to conditionally format a range (say A1:A1000) with the following
criteria;

For each cell in the range(A1:A1000), how many of the other cells in that
same range, share the first 4 characters - if greater than 1; format.....,
etc.?

I looked at the countif function, but couldn't find a way to apply it and
I'm stuck for alternatives.....

Any bright ideas?

Conditional Formating by truncated values....
 

select A1:A1000 with A1 as the active cell

do format=Conditional Formatting

change cell value is to Formula is

Enter this formula

=COUNTIF($A$1:$A$1000,LEFT(A1,4)&"*")1

click the format button and select the shading.

--
Regards,
Tom Ogilvy


"JB2005" wrote in message
...
I wish to conditionally format a range (say A1:A1000) with the following
criteria;

For each cell in the range(A1:A1000), how many of the other cells in that
same range, share the first 4 characters - if greater than 1; format.....,
etc.?

I looked at the countif function, but couldn't find a way to apply it and
I'm stuck for alternatives.....

Any bright ideas?

Conditional Formating by truncated values....
 

Thanks Tom,

So simple when you understand how...
;-)

"Tom Ogilvy" wrote:

select A1:A1000 with A1 as the active cell

do format=Conditional Formatting

change cell value is to Formula is

Enter this formula

=COUNTIF($A$1:$A$1000,LEFT(A1,4)&"*")1

click the format button and select the shading.

--
Regards,
Tom Ogilvy


"JB2005" wrote in message
...
I wish to conditionally format a range (say A1:A1000) with the following
criteria;

For each cell in the range(A1:A1000), how many of the other cells in that
same range, share the first 4 characters - if greater than 1; format.....,
etc.?

I looked at the countif function, but couldn't find a way to apply it and
I'm stuck for alternatives.....

Any bright ideas?