i-nth - How to use Conditional Formatting in Excel

12 May 2019

This article shows over 20 different ways that you can use Conditional Formatting, starting with some basics and presenting some advanced techniques as well.

Many of the examples are templates that you can download and experiment with.

Full article: How to use Conditional Formatting in Excel

Connexion
Vertex42

Essential reading

10 Reasons for Excel formulas not working

"Oh My God" my formulas are not working! This article covers most of the reasons for Excel formulas not working. And how to fix them.

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.