Have you ever wanted to flag results in a data table that matched your criteria? Or wanted to see just by glancing which result in a list of values was the largest value or the smallest value? That's what conditional formatting will let you do.
Conditional formatting allows you to take a range of cells and highlight those that are above or below a certain value.
Or to add icons or bars or colored shading to a cell to show which are your largest or smallest values.