Add table formatting with cell style rather than replace all existing formatting
When doing financial table I need to added extra space or strike to rows while also adding fills to some columns, also some columns have different text style eg Bold, Italic etc.
With Cell Styles they override the existing formatting.
I would like to be able to add these as a Cell Style to a row without replacing the existing format . This would be a bit like a nested style.
Graham Park
shared this idea
-
Tim Sheasby commented
This is possible – 1. A default cell style must be set in the table style that sets EVERY option for the default (including rules, rule weights, colour, spacing, etc). 2. New cell style must NOT be "based on" your defined default cell style and must ONLY add or change specific settings required. If it IS based on the default it will apply all the default settings as well as your new settings – an undesired result. In this way, it will not override any defaults and should not affect other cells with custom cell styles applied. I use this technique all the time so I know that, if done properly, it works 100% of the time.