Home > Format > ConditionalFormatting > Topics
See how to get started with Excel conditional formatting, or find new ways to use conditional formatting in your Excel workbooks. For example, highlight cells or an entire row, hide duplicate headings, use data bars, or shade alternate rows.
-- Conditional Formatting Basics
-- Video: Highlight Cells Based on Value
-- Format Row Based on One Cell
-- Conditional Formatting Examples
-- More Conditional Formatting Info
With Excel conditional formatting, you can highlight one or cells, by setting rules (conditions) for those cells,
For example, set a rule to turn cells red if they have a number that is below 50
As you can see in this screen shot, conditional formatting makes it easy to identify months with low sales.
To make it easy to find cells with high or low numbers, use conditional format the cells, based on their values. For example, in this video, two rules are set for cell formatting:
For written steps, and a sample Excel workbook, go to the Excel Conditional Formatting Intro page.
In addition to cell fill colour, you can use other types of conditional formatting on your Excel worksheet.
For example, use an Icon Set with red, yellow and green arrows. That quickly shows if numbers are high, average, or low, compared to other numbers in the list.
If cells contain numbers, you can add conditional formatting data bars, to show the differences among the amounts.
Watch this short video to see how to set up data bars in a cell, and the written instructions are on the Conditional Formatting Data Bars page.
You can apply conditional formatting that checks the value in one cell, and applies formatting to other cells, based on that value. For example, if the values in column B greater than 75, make all data cells in the same row blue.
You can watch the steps in this video, and the written instructions are on the Format Row Based on One Cell page.
There are many ways to use conditional formatting, to help you highlight information in your Excel worksheet, or find problems quickly, or even hide information until it is needed.
There are two examples in the videos below, and many more on on the Conditional Formatting Examples page.
In this example, there is a region named entered in each row. With conditional formatting, the second (and subsequent) occurrences of each region name have white font colour, to make the report easier to read.
You can watch the steps in this video, and the written instructions are on the Conditional Formatting Examples page.
To make a list easier to read, you can use Excel conditional formatting to shade alternating rows on the worksheet.
You can watch the steps in this video, and the written instructions are on the Conditional Formatting Examples page.
Here are links to more Excel conditional formatting tutorials from Contextures:
Conditional Formatting Documenter
Conditional Formatting Show List and Colors
Conditional Formatting Problem
Last updated: November 9, 2022 2:58 PM