Formatting

Hello,

First off I have Excel 2010 for my Mac.

I have 2 workbooks that have the same names in both. Is there anyway to apply the formatting from the source workbook to the other one? I.E. highlighting.

For example, I have Jane Doe in the one workbook and I want to highlight her name but I also want her name highlighted in the second workbook so I don't have to do the same thing twice. Is there anyway to do this?

I know what I want Excel to do for me but I don't know how to explain it clearly.

Thank you for any help,

Logan

There is no formulaic way of doing that, unless the highlighting is applied via conditional formatting, and if it is then you just need to apply the same rules in your second sheet.

If the colour is applied manually then you would need a macro to mirror the effect in your other file.

Hope this helps.

Pete