Скачать или смотреть How to apply conditional formatting using highlight cell rules based on the criteria of less than

This video is for absolute beginners. In this video, you will see how to apply conditional formatting using the using highlight cell rules (less than) in MS Excel
Use a conditional format to help you visually explore and analyze data, detect critical issues, and identify patterns and trends.
Whenever you analyze data, you often ask yourself questions, such as:

Where are the exceptions in a summary of profits over the past five years?
What are the trends in a marketing opinion poll over the past two years?
Who has sold more than $50,000 dollars this month?
What is the overall age distribution of employees?

Conditional formatting helps to answer these questions by making 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. A conditional format changes the appearance of a cell range based on conditions (or criteria). If the condition is true, the cell range is formatted based on that condition; if the conditional is false, the cell range is not formatted based on that condition.

You can sort and filter by format, including cell color and font color, whether you have manually or conditionally formatted the cells.