![]() ![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |