Sample Data for conditional formatting to highlight a row Using Conditional Formatting to Highlight a Row We want to highlight the rows for products with the color “Black”.įigure 2. Here we have a table showing Products A to G, with corresponding Color, Size and Pieces Sold. Using conditional formatting to highlight a row Setting up the Data This step by step tutorial will assist all levels of Excel users in highlighting rows or columns based on a condition.įigure 1.
There are instances when we need to highlight a row or a column, depending on the data we have and the desired results.
Use Conditional Formatting to Highlight a Row or ColumnĬonditional Formatting is a feature in Excel that allows us to change the format of cells based on a set of rules or conditions.