Avoid frustration and unintended formatting by learning how Excel applies conditional formatting rules.

The decision to use a spreadsheet format that dates back to the 1980s has proved to be unwise.