i-nth - Using icon sets to create visual effects to compare cell values

3 August 2013

Icon Sets in Conditional Formatting create a visual effect in your data so that you can compare the value of a cell with other cells. For example, if you are an accountant and want to easily categorize debtors based on how much they owe your company you can use Conditional Formatting – Icon Sets.

Full article: Using icon sets to create visual effects to compare cell values

Essential reading

Spreadsheets are code

Spreadsheets can be considered to be the world's most successful end-user programming language. Spreadsheet formulas are Turing complete.

Latest articles

Spreadsheets as a source of analytical and accounting problems
Self-checks in spreadsheets: A survey of current practice
The development of a structured methodology for the construction and integrity control of spreadsheet models
Refactoring meets spreadsheet formulas
Simple spreadsheet test case application to test spreadsheet formula in end-user software engineering
Proper VBA error handling
VBA Like operator – using wildcards in conditional statements
Count cells with text and formula – Excel stats
VBA: The VBA array
Excel Tables
An innovative spreadsheet authoring environment

Consulting

We can help you make better spreadsheets:

Reviewing your spreadsheets for errors.
Advice about improving your spreadsheets.
Training in spreadsheet good practice.