| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing formatting of two cells
Situation: Two cells contain the same text, and have the strikethrough format
applied to different subsets of the text. Example: Cell 1: THE QUICK BROWN FOX <start strikethrough JUMPED OVER <end strkethrough THE LAZY DOG. Cell 2: THE <start strikethrough QUICK BROWN <end strikethrough FOX JUMPED OVER <end strkethrough THE LAZY DOG. If the whole cell has the Strikethrough font attribute applied, then Cell.Font.Strikethrough is True. If none of it has the Strikethrough attribute applied, then Cell.Font.Strikethrough is False. If only some of it has the attribute applied, as in the examples above, then Cells.Font.Strikethrough is Null. Is there some way VBA can compare two cells formatted in the examples above and identify that there is a difference between them? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing three columns, Conditional Formatting | New Users to Excel | |||
| Conditional formatting comparing two columns | Excel Worksheet Functions | |||
| Conditional formatting comparing times | Excel Worksheet Functions | |||
| Comparing two lists using Conditional Formatting | Excel Worksheet Functions | |||
| Conditional formatting/ comparing worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
