I’m a big fan of Excel’s conditional formatting, and often use it to highlight cells on a worksheet.
The value of this property can be set to one of the constants: xl Underline Style None, xl Underline Style Single, xl Underline Style Double, xl Underline Style Single Accounting, xl Underline Style Double Accounting.
The following code sets the font of cell A1 to xl Underline Style Double (double underline).
But this week I ran into a conditional formatting crisis, and had to start from scratch.
Fortunately, the fix didn’t take too long, but with complex formatting, things could have been much worse.
The value of this property can be set to one of the constants: xl RTL (right-to-left), xl LTR (left-to-right), or xl Context (context).