BrushTools Demonstration

How does it work?

BrushTools add-in is extremely user-friendly and easy to use.

A BrushTools ribbon (toolbar) is added to Microsoft Excel, providing the user with added functionality.

By clicking the "Font Brush" button in the BrushTools add-in toolbar, the font (numbers, text and characters) in each cell in the active sheet or within a selected range of cells (as described below), is instantly colored according to the type of underlying formula. By linking font color to formula type, BrushTools provides the user with an immediate view of the formula underlying each cell, making it possible to simultaneously view both cell value and formula type.

Since this operation is semi-dynamic, we recommend that you carry it out at least three times: when you start your work with the workbook, when you finish your work and begin the testing stage, and when you finish the testing stage.

This operation is perfectly safe. All that BrushTools does is to paint the fonts within a specified range in the color assigned to each type of formula.

 

BrushTools Add-in Ribbon (Toolbar) Screen Capture in Microsoft Excel 2010:

BrushTools add-in toolbar 2010

 

BrushTools Add-in Ribbon (Toolbar) Screen Capture in Microsoft Excel 2007:

BrushTools add-in toolbar 2007 fit 2

 


Description of BrushTools Add-in Toolbar Functions (Buttons):

Font Brush (Ctrl+Shift+Q) (split button)
Font Brush the active sheet according to the active range.

 

Font Brush: Paint the font (text) color of each cell in the specified range (as described below) according to its type of formula.

 

The specified range: If the active range only includes a single cell, paint all cells in the active sheet. However, if the active range includes more than one cell, paint all cells within the active range.

 

Font Brush Active Sheet Fully
Ignore the active range and paint the active sheet entirely.

 

Font Brush All Sheets According to Active Range
Paint the specified range in each visible sheet, in the active workbook.

 

Font Brush All Sheets Fully
Ignore the active range and paint each visible sheet entirely, in the active workbook.

 

Font Black Active Range (split button)
Paint text selection in black.

 

Font Black Active Sheet Fully
Paint in black the text of the active sheet entirely.

 

Font Black All Sheets Fully
Paint in black the text of each visible sheet entirely, in the active workbook.

 

Font Color
Paint text selection in 1 of 56 color palette colors.

 

Fill Color
Paint background of selection in 1 of 56 color palette colors.

 

Settings
Open the BrushTools settings menu.

 

Color Palette (menu button)
Active workbook color palette.

 

Reset Color Palette
Reset active workbook color palette (the 56-color palette).

 

Import BrushTools Color Palette
Import BrushTools customized color palette (the 56-color palette) into the active workbook.

 

License Agreement
Show the BrushTools add-in license agreement.

 

Software Version Details
Show BrushTools software version details.

 

 

Feature Menus Screen Capture

The BrushTools Settings Menu has two predefined work levels - "Basic" and "Professional" (shown below). Under "User Selection" the default colors may be changed at the user's discretion, in the following way:

Click on the chosen Color Button which shows the Color Picker (shown below). Click on one of the 56 color palette colors in the Color Picker, which update the color of the chosen Color Button, then, press OK in the Settings Menu to update the BrushTools add-in settings for the color assigned to each type of formula.


Basic
Level:

BrushTools add-in menu basic


Professional
Level (Default
selected):

BrushTools add-in menu pro 3


Color Picker (56-color palette colors):

color picker