by Matthias Bürcher @ 2017
This macro provides simple inline cell formatting, without modifying the formula.
The zip file contains:
- style.xlam: The add-in
- demo.xlsm: The macro sheet, from that the add-in was exported
- styledemo.xslm: A demo file
Install style.xlma (menu Tools:Excel add ins)
Use commands on selected cells:
- Command-option-shift-S for style
- Command-option-shift-R for reset
Double single quote for italic.
Triple single quote for bold.
Quintuple single quote for italic bold.
The formula of the cell is not modified.
Quotes are formatted background color and size 1.
Text color is preserved.
Background color is preserved
Quote as a first character has a special meaning in Excel.
Add a quote if you start with a italic or bold text