PDA

View Full Version : Border war



austenr
09-08-2010, 10:42 AM
I created a style that takes away borders and changes the font in a range of cells. That's not the problem.

When I try to reverse it with the opposite of the style I used and it puts borders around the cells inside the range which has a border around it.

So is there a way to just reverse the style I used to take away the borders that were there originally and revert back to what it was before I applied the style? :banghead:

WB attached. Cells in question are on the Direct Bill Only tab. Range C22:F25.

Bob Phillips
09-08-2010, 11:44 AM
I wouldn't think so. A style overlays that format, it doesn't remove some added format.

austenr
09-08-2010, 11:48 AM
So I am up the creek as it were?

Bob Phillips
09-08-2010, 04:11 PM
If you need to do it that way yes. What I did was to create a styles addin, and one of the functions was a toggle through a series of borders. So it was easy to set a border on cells, but it was just as easy to set it to another.