View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris B Chris B is offline
external usenet poster
 
Posts: 11
Default 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?