LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining Text and If statements with varied character (bold, color, etc) formatting. JEFF Excel Discussion (Misc queries) 10 June 12th 07 01:24 PM
Lookup and change to italic italic Doug Excel Worksheet Functions 2 October 30th 06 01:39 PM
change format of cells (bold, italic) based on one cell's answer Jabi Excel Discussion (Misc queries) 4 May 25th 06 12:33 PM
How to apply both Italic & Bold in Header & Footer? Regina Man Excel Discussion (Misc queries) 1 September 26th 05 09:35 AM
identify data in a cell that has a number as the second character Brian Excel Worksheet Functions 1 December 12th 04 03:23 PM


All times are GMT +1. The time now is 07:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"