View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
alphaorionis alphaorionis is offline
external usenet poster
 
Posts: 4
Default Formula to identify character formatting (bold, italic, etc)

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.