The only difference is in the formula we use to satisfy the condition. The steps for highlighting a column are similar to that of highlighting a row. Sample Data for Conditional Formatting to Highlight a Column Using Conditional Formatting to Highlight a Column In the same manner as the previous example, we want to highlight the columns for products with color “Black”.įigure 9. Here we have a similar table as the above example, only that the headers are in the leftmost side and the information per product is shown per column. Setting up the Data for Highlighting a Column There are also cases where we need to highlight a column because the data we have requires it that way. Output: New conditional formatting rule reflected in the rows of data with the color “Black”Īs shown, we are able to change the format of the entire row for Products A, D and G with color “Black”. This rule highlights the rows of data that satisfy the condition of Color= “ Black”.įigure 8. Completion of the new formatting rule with formula and selected format Select “Fill” and choose Orange, Accent 6, Lighter 60% and click OK.įigure 7. We can change the font, borders or fill the cells with different colors. To change the format, click “Format” and then decide on the new format to apply to the entire row. Entering the formula as a condition or formatting rule For every row of data, the format will be changed if the “Color” is “Black”.įigure 5. This formula triggers the conditional formatting, and the “$” before “C” ensures that the reference column is only the column for “Color”. Note that the column is fixed by using the symbol “$”. To highlight a row, we fix the column that serves as the reference for the conditional formatting Select the Rule Type “ Use a formula to determine which cells to format ” and enter this formula in the dialog box : Creation of a new rule in conditional formatting The New Formatting Rule dialog box will pop up.įigure 4. Click the Home tab, then the Conditional Formatting Menu and select “ New Rule ”.
Selection of the data range for conditional formatting In this case, select cells B4:E10.įigure 3. To highlight an entire row, we use Conditional Formatting and enter a formula based on the required or given criteria. 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.
0 kommentar(er)
