When you right click on an Excel worksheet cell, you can change its numeric type, alignment, background color, and other properties. But did you know that you can have the cell change its format if ...

Identifying duplicates quickly While Excel offers a few different methods to help you isolate duplicate values, conditional formatting can highlight values that are duplicates. Much like the first ...

Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.

Conditional formatting was one of the areas that benefitted greatly from the enhancements introduced in Excel 2007. Prior to the 2007 update, each conditional format had to be set up manually and a ...

Understanding your data and how Excel's conditional formatting works is the key to accurately using icons to represent data.

Conditional formatting is a simple tool that allows you to visually highlight information based on a set of criteria and can be used in a variety of ways. As an example, suppose you have an Excel ...