Home / Formatting

Formatting

Multi Rule Conditional Formatting

We had a website visitor looking to apply multiple conditional formats to a table. Two (2) of the rules were working, but the third just wouldn't apply correctly. We reviewed the rules and found a couple of quick files to resolve the problem.

Read More »

Change Cell Formats using Ranges and Offset

The following Macro has been designed to read through a range of cells and update the Cell formats for Font, Color, Borders and Background Color. This type of Macro can be really useful in worksheet updates where inserts, updates and deletion of cells can result in a loss of formatting for the worksheet. With this Macro the formats can be re-applied with one command after all the updates are made.

Read More »