Microsoft Excel Conditional Formatting based on Another Cell: -

Use Conditional Formatting to Highlight Information
Use conditional formatting to help you visually explore and analyze data, detect critical issues, and identify patterns and trends.

Conditional formatting makes it easy to highlight interesting cells or ranges of cells, emphasize unusual values, and visualize data by using data bars, color scales, and icon sets that correspond to specific variations in the data.

A conditional format changes the appearance of cells on the basis of conditions that you specify. If the conditions are true, the cell range is formatted; if the conditions are false, the cell range is not formatted. There are many built-in conditions, and you can also create your own (including by using a formula that evaluates to True or False).

Note: Formatting options that affect the size of rows or columns are not available in Conditional Formatting Rules. This includes the font and font size, and certain border styles.

Highlight Excel Cells Based on the Value of Another Cell: Learn how to highlight cells based on another cell's value. A cell value may be a number, text or date, all types of number format you can use in formula. This tutorial tells you very smoothly, softly and delicately.

свернуть