Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - Drawing Lines Between Sorted Groups
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 -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - Drawing Lines Between Sorted Groups
=AND(A1<A2,COUNTIF(A:A,A1)1)
HTH -- AP "Sam via OfficeKB.com" <u4102@uwe a écrit dans le message de news: 60d2b70288bf9@uwe... 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 -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - Drawing Lines Between Sorted Groups
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 Ardus Petus wrote: =AND(A1<A2,COUNTIF(A:A,A1)1) HTH -- AP Hi All, [quoted text clipped - 6 lines] Cheers, Sam -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200605/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting for groups | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) |