Hi Bernie!

Thanks for the input but this solution doesn't work in my case. The reason
being that some changes were carried out in Book 1 and others in Book 2.
Hence there is no one workbook which can be considered as the "master" copy
which can be used to copy and paste the formatting.

Hope you can help out.

Thanks and Regards,

Shahvir.

"Bernie Deitrick" wrote:

I want to ensure that the character formatting, i.e.,
bold, underline, italic for each of the cells in both the worksheets is the
same.

Select all the cells of one sheet, press Ctrl-C to copy them, then select the cells of the other
sheet, and use Edit / Paste special / formatting and the formats of all the cells will be the same.

HTH,
Bernie
MS Excel MVP


"alphaorionis" wrote in message
...
I'm using MS Excel 2003. I have to spreadsheets / worksheets running into
several thousand lines. I want to ensure that the character formatting, i.e.,
bold, underline, italic for each of the cells in both the worksheets is the
same. Is there any formula which would help me do this?

The CELL function only identifes color and number formatting but not
character formatting such as bold, underline, italic, etc., while the EXACT
function ignores formatting.

Is there any formula / function / workaround which would enable me to find
out if two cells are formatted exactly the same.