Excel - automatically draw border where data changes 1

[TheSouthCole]

Hello, everyone!
Is there a way to have a bottom border drawn automatically under the last row of data, for example:

ColA ColB ColC
1 data data
1 data data
1 data data
----------------
2 data data
2 data data
-----------------
3 data data

where ----- represents that the row above automatically received a bottom border format because the data in ColA has changed.

If this can be done without VBA, it would be easier for me!
Thanks for any help or insight!

 

[bluedragon2]

Try this, Highilite A2 down and click menu item format/conditional formatting

in the first box, put formula is and in the second box, put =A2<>OFFSET($A$1,ROW()-2,0)

Then format for the top border.

Repeat for col b and then col c.



Blue

If I wasn't Blue, I would just be a Dragon...

 

[bluedragon2]

Actually I put to much into it, instead of =A2<>OFFSET($A$1,ROW()-2,0), you could just put =A2<>A1

and if you highlite all three columns and put =$A2<>$A1

you can do them all at once...



Blue

If I wasn't Blue, I would just be a Dragon...

 

[TheSouthCole]

Hi, Blue!
Makes perfect sense. However, when I applied to all the test cells, I only got a bottom border at the very end of my range.

Ideas? ...and THANKS!

 

[TheSouthCole]

Never mind, Blue!
It did work. (I had a simple blonde-error, which I fixed.)
Thanks very much!

 

[SkipVought]

HEY SOUTH!

BLUE deserves a STAR.

Not only because he helped you out with ... a helpful/expert post! but also because it identifies the post to others who are looking for helpful/expert assistance.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com