XLplus Add-On: Color every n-th Range
You can use this Tool to color every n-th, i.e. second, row or column of a given range.
Selection Settings
Specify whether rows or columns shall be colored. Additionally specify the step width, i.e. specify 5 in order to color every 5th row.
Options
Specify if
- hidden cells are skipped - they will not be colored if this option is enabled
- Conditional Formatting will be used - see below
- existing colors will be removed, before new colors are set.
Conditional Formats
This option applys the color by use of a conditional format. The benefit of this option is, that you can sort your data afterwards, without loosing your formatting. The drawback of this option is, that all of your existing conditional formats within the data range will be lost, after you used this tool.
Tip: Since applying colors is done within seconds we recommend to avoid using the conditional format option - it is easier to sort your data and reapply colors using this Tool again afterwards. This is done in seconds and your conditional formats still work and shine through.
More Colors
XLplus Ver.: 2.50
Using XLplus Ver.: 2.50 on MS Excel 2000 until MS Excel 2003 you are restricted in the amount of colours you can use. Option More Colors will be deactivated.
Tip: Use Color Management, in order to adapt the Workbooks available colors to your needs. Using this Tool, you can easily lighten or darken the available colors or add special colors to the available palette of colors.
XLplus Ver.: 3.0.X
Using XLplus Ver.: 3.0.X on MS Excel 2007 or higher you can choose from millions of colors by using option More Colors.
Versions:
Ver.: 2.0.1 and Ver.: 3.0.1 allow using every color within MS Excel 2007+.
See also
Bookmark
File Explorer
Extract Information Wizard
Brut - Net Calculator