Hi John,

The problem is, I can't afford to overwrite any formatting of a cell. The
plan was to copy the formatting of a 'sample' cell, and paste it across the
data that comes from other teams.

It's only the bordering that needs to be included, changing the colours of
existing cells is exactly what I don't want to do.

Any clues?

Many thanks for your help this far.

"John Keith" wrote:

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!