Use conditional formatting in Excel to make data easier to read. Use the Excel conditional formatting function to better visualize data too.
Let's say you have a spreadsheet with thousands of rows of data. It would be extremely difficult to see patterns and trends just from examining the raw data. Excel gives us several tools that will make this task easier. One of these tools is called conditional formatting. With conditional formatting, you can apply formatting to one or more cells based on the value of the cell. You can highlight interesting or unusual cell values, and visualize the data using formatting such as colors, icons, and data bars.
In this lesson, you'll learn how to apply, modify, and remove conditional formatting rules.