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 A4:E10.įigure 3. Sample data for conditional formatting to an entire row Applying Conditional Formatting to an Entire Row We want to highlight the people that are below 18 years of age and apply the format to not just the “Age” column but to the entire row.įigure 2. Applying conditional formatting to an entire row Setting up the Data This step by step tutorial will assist all levels of Excel users in applying conditional formatting to an entire row.įigure 1.
Conditional formatting can be applied to a set of selected cells, including an entire row. How to Apply Conditional Formatting to an Entire RowĬonditional Formatting is a feature in Excel that allows us to change the format of cells based on a set of rules or conditions.
