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.
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.