In this example I will go over the simple steps on how to apply Conditional formatting with Highlight cells.

I have pulled some data relating to Lego sets and want to highlight the sets that have over $100$ pieces.

First Once you have your table formatted, Navigate to the home tab.

Click Home tab.jpg

Select the data you wish to format.

select data.jpg

Click Conditional Formatting and navigate to the Highlight Cell Rules section. With the Highlight Cells Rules section selected choose Greater Than in the drop menu.

condition.jpg

Enter your Criteria in the Pop$-$up box And Click OK

click ok$.$jpg

Click any empty cell to deselect the data

empty.jpg

Read Less