Microsoft

Office

Excel

Add-In

Format

You can think of this add-in as an extra strength version of Excel’s conditional formatting feature. Rather than being limited to applying conditional formatting on a single cell only (as with conditional formatting), the DTG Advanced Formatting add-in can apply formatting to entire rows or columns that match the criteria you specify.

DTG Advanced Formatting can also apply repeated, alternating formats. For example, a common practice is to lightly shade every other row in a long list so that it’s easier to follow the row across the worksheet. The DTG Advanced Formatting add-in allows you to perform this task in a matter of seconds.

The bottom line is that if you frequently work with lists in Excel, you will save yourself time while formatting by employing the features found in the DTG Advanced Formatting add-in.

- Conditional and Alternating formatting
- Settings tab allows you to specify formatting options
- Quickly format both rows and columns
- Alternating formatting features
- Choose the row/column block size
- Choose the frequency
- Conditional formatting features
- Choose up to 3 conditions that define the match criteria
- Use logical 'And'/'Or' conditions for more powerful conditional statements
- Choose among various logical operations such as: begins with, between, equal to, >=, empty and many more.
- User defined templates allows you to specify every aspect of the formatting design
- Secondary template option for additional formatting power
- Save, Remove and Preview your designed templates
- Dynamically defined user specified working range
- Empty row insertion option
- Auto End feature determines the last row/column of data and stops the formatting rules accordingly
- Auto Follow feature shows you the range you are referring to when using DTG Advanced Formatting