Turn raw data into actionable insights with Excel 365’s conditional formatting. Learn to create dynamic visuals with ease in ...

Excel lets you set some conditional formatting rules that highlight cells within a given range. When you specify these ranges, you can quickly and easily see the data that are most important to you.

Open the Excel worksheet in which you want to find and highlight the duplicate cells. I have created sample data of marks scored by 10 students in different subjects.

The Focus Cell color is a fainter shade of whichever color you select, so that you can still read the data in the colored cells. Here, I've selected red, and you can see that the bands are pinky-red.

Highlight one or more cells in a column and click "Conditional Formatting" in the Styles section of the Home tab on the ribbon. Click "Highlight Cell Rules" to display a menu that contains If-Then ...

All the cells of negative numbers will become red, while the positive numbers will remain the same. You can create your own custom format in Excel to highlight negative numbers. Select the range ...

If you select a range, Excel applies that green border to the entire range. The active cell in that range is still white (or clear), but Excel applies a gray shade to the remaining cells, as shown ...

Select the data range, B3:E16–you want to highlight the entire row. If you use a Table, Excel will update range as you add and delete records. The demonstration file contains a Table example.