Log in  \/ 
x
or
x
x
Register  \/ 
x

or

Excel Tips: Format > Conditional Formatting

Conditional Formatting Duplicate or Unique Values

How to color duplicate values or duplicate rows in Excel?

How to conditional format or highlight first occurrence (all unique values) in Excel?

How to conditional formatting duplicate cells in a column in Google sheet?

How to find and highlight the duplicate names which both match first name and last name in Excel?

How to highlight cells if not in another column in Excel?

How to highlight cells with same/duplicate values in Excel?

How to highlight column differences in Excel?

How to highlight consecutive duplicate cells from a list in Excel?

How to highlight duplicate rows across multiple columns in Excel?

How to highlight duplicate values except first instance in Excel?

How to highlight duplicate values in different colors in Excel?

How to highlight the duplicates and overlapping dates in Excel?

How to highlight the last duplicate row/cell in Excel?

How to highlight/conditional formatting unique/duplicate values in Excel?

Highlight Top or Bottom Items

How to highlight cells above/below average in Excel?

How to highlight largest / lowest value in each row or column?

How to highlight max and min data points in a chart?

How to highlight or conditional formatting the max or min value in Google sheet?

How to highlight/conditional formatting top n values in Excel?

Icon Sets

How to change conditional formatting icon set color in Excel?

How to compare adjacent cells with Conditional Formatting icon sets in Excel?

How to create a five-star rating system in Excel?

How to use icon sets to highlight values in conditional formatting in Excel?