Conditional Number Formatting

If the value in cell satisfies a user-specified condition, use the Conditional formatting it is possible to allocate this cell (for example, change its background). In this article, go ahead - will highlight the entire table row containing this cell.

Consider rule Conditional formatting - Set of icons.

Find the number of unique numeric values in the specified multi-column range.

Use Conditional formatting to highlight table rows in which the number belong to a certain range. For example, if the number in a particular column is less than 0, then the entire row will be highlighted in red.

Use Conditional formatting for the allocation of numbers belonging to subscribers of Moscow.

Use Conditional formatting to signal to the user when they enter an incorrect value. Under the "incorrect value" here will understand the meaning, does not belong to the specified range.

Sometimes you want to hide values equal to 0. Do this a few ways.

here are the search numbers in the list with repetitions. Setting as a criterion to search for the desired value and number of repeat in the list, find the row number containing this repeat, and select it and other repetitions of this numbers using Conditional formatting.

Scroll Conditional formatting the three largest values in the list.