Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Text and If statements with varied character (bold, color, etc) formatting. | Excel Discussion (Misc queries) | |||
Lookup and change to italic italic | Excel Worksheet Functions | |||
change format of cells (bold, italic) based on one cell's answer | Excel Discussion (Misc queries) | |||
How to apply both Italic & Bold in Header & Footer? | Excel Discussion (Misc queries) | |||
identify data in a cell that has a number as the second character | Excel Worksheet Functions |