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.

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.

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.

Harlan Grove once wrote a UDF that can do this (no built in functions can do
that) among other things

ftp://members.aol.com/hrlngrv/ExtCell.zip


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)



"alphaorionis" wrote in message
...
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.