Conditional Formatting - Drawing Lines Between Sorted Groups

[Sam via OfficeKB.com]

Hi All,

Can anyone provide a Conditional Formula that can draw a line between Rows of
sorted groups of data BUT only draw the line if, or when the group contains
more than one Row (of the same data) in its sorted group.

Cheers,
Sam

 

[Ardus Petus]

=AND(A1<>A2,COUNTIF(A:A,A1)>1)

HTH

 

[Sam via OfficeKB.com]

Hi Ardus,

HTH

It most certainly did the job! Thank you ever so much for your help.

=AND(A1<>A2,COUNTIF(A:A,A1)>1)

I just absoluted the columns.

Cheers
Sam

=AND(A1<>A2,COUNTIF(A:A,A1)>1)

HTH
--
AP

Hi All,

[quoted text clipped - 6 lines]

Cheers,
Sam