Alternating row or column colors assists data identification by making the row or column easier to distinguish. In Microsoft Excel, you can achieve this effect using conditional formatting to change ...

Excel Conditional Formatting already lets you format cells based on the value of those cells or the value of the formulas in those cells (see our conditional formatting tutorial for more details). Now ...

Formatting every other row is easily accomplished using conditional formatting. Fortunately, conditional formatting can handle something more specific, formatting every even or odd row. Many users ...

Microsoft Excel’s conditional formatting is a wonderful “automatic” feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells. For example, ...

One of the most common requests I receive from users is how to identify duplicate and unique values in Microsoft Excel. The easiest way I know is to apply a conditional format. In a nutshell, a ...

Business issues such as incorrect transactions, data entry errors, technical glitches and poor system design may cause duplicate values in your data sets. Duplicate values can exist across rows or in ...