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

Allocate cells containing the text. Consider different options: select the cells containing values identical to the search text, the selection of cells that contain the search text in the beginning, end, or middle of the row. Learn how to highlight a cell if its value matches with one of multiple specified values.

If grid data is sometimes necessary to restrict the option of entering a specific list of values. For example, when filling out the statement enter the names of the employees from the keyboard can be replaced by selection from a predefined list (time sheet), and to control the re-entry of names in the list, use Conditional formatting.

Set Conditional formatting to highlight only the distinct values and is case-sensitive. Ie the values "Smith" and "Smith" will be considered as non-repeatable (different values).

Allocate cell that contains the search text is case-sensitive. Consider different options: select the cells containing values identical to the search text, the selection of cells that contain the search text in the beginning, end, or middle of the row.

are counting unique non-recurring text values not in the list, but only in a user-defined range.

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

Consider the search text values in the list with repetitions. By setting the criterion to locate the text value and number of repeat in the list, find the row number containing this repeat, and scroll to it, and other duplicates by using Conditional formatting.