Copy Cell background & font colors between cells without changing receiving cell borders

[pongmeister]

I have a macro set up to copy paste "formats only" from one cell to a receiving cell. Is there a way I can copy all formats except the borders. I'm writing code to run a tournament and the bracket borders are being changed when ever I do the past/special formats option.

I have so many cells I have to change that it is impractical to set up conditional formatting.

Thanks for any help.

[6StringJazzer]

You can't select an attribute to omit, but you can select which ones you want to copy. What are the formatting attributes you are interested in? Instead of using Copy then PasteSpecial you will have to do something like this, for example, to copy font color, font bold, and fill color:

Please Login or Register  to view this content.

[6StringJazzer]

I have so many cells I have to change that it is impractical to set up conditional formatting.

I missed this the first time. The number of cells has nothing to do with how much effort it is to set up conditional formatting, and I suspect this is going to be your best bet. It may be that conditional formatting is simpler than you think. Can you provide a sample file and give more details about your criteria for formatting?

[pongmeister]

Hi 6StringJazzer,

Thanks for the fast and exactly what I need solution. I tested it now and it worked perfectly. You have saved me a great deal of time and complex coding.

[pongmeister]

I'm not an expert but I have setup a lot of conditional formatting and have a fair grasp. However, I'm running a 32 team double elimination and am coloring each teams brackets with a unique color/font combination. So on the initial matches it's easy to set up conditional formatting so when first match ends you have to check the color on either the loser or winner and set it in the next round accordingly. But on the next round there are 4 teams that could possibly be the winner and loser. Then the next round you have 8 teams possibly reaching the bracket. until you get to where you have to have check for 32 teams in the final match.

Actually, your first solution is exactly what I need. I was doing a copy paste special (Formats). That gave me the background and font colors correctly but messed up the borders on the receive cell. Your solution above solves the issue and makes it simpler than using conditional formatting.


I'm attaching my workbooks to let you see what would be involved, but I wouldn't spend too much time on it since your first solution works so well.

I control who won/lost each match in the DoubleElimDrawSheet.xlsm book by entering results in the DoubleElimResults.xlsm book. I put "Upper" or "Lower" in column B on row where column A contains the Match ID (W1 thru W34) then my code puts the winner and loser in their next bracket (Loser goes to the Left side of the sheet and winners go to the right. The third book (DoubleElimEntries.xlsm) Contains the team entries and is used to load players to the beginning matches.

The macro I use to copy/paste special colors and fonts is named "ExtrapolateColors"

Thanks so much again.

[pongmeister]

Hi 6StringJazzer,

I submitted another issue with this string but I don't see it in the string now but that's just as well since I found the answer, so I am closing this thread now and thanks again for all your help!