Have you tried using Copy then Paste-Special (choosing "Formats")

Shading and text color will still get pasted, but the text/number values are
not copied. Then select the area(s) just pasted and turn off the
color/hilighting.

This whole process could be "recorded" into a macro to clean-up after your
other teams.

Depending on how your cells are formatted, you could re-assign the "correct"
format as part of the process too (since "Formats" applies to much more then
just the borders)

--
Regards,
John


"Jamie" wrote:

Hi guys,

We use excel to design layouts for some software, and this requires a rather
complex screen layout that gets emailed to many people. As such, when it's
amended by other teams, they seem to like breaking the formatting...

Is there a way that I can copy the borders of a cell, without taking the
contents (text) of shading that is already in place?

I'd really appreciate some help with this! My life would be SO much easier!