14.2 C
London
Tuesday, May 28, 2024
HomeSoftware TutorialsExcelExcel: How to Highlight Entire Row Based on Cell Value

Excel: How to Highlight Entire Row Based on Cell Value

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

Often you may want to highlight an entire row in Excel based on a given cell value in the row.

For example, you may want to highlight each row in the following dataset in which the value in the Passed column is “Yes”:

Excel highlight rows based on cell value

This is easy to do using the Conditional Formatting feature in Excel.

The following example shows how to do so in practice.

Example: Highlight Entire Row Based on Cell Value in Excel

Suppose we have the following dataset in Excel that contains information on the total hours studied, final exam score, and passing status of various students in some class:

Now suppose that we would like to highlight each row in which the value in the Passed column is “Yes.”

To do so, we can highlight the cell range A2:D11, then click the Conditional Formatting icon, then click New Rule:

In the new window that appears, click the option called Use a formula to determine which cells to format, then type =$D2=”Yes” in the box, then click the Format button and choose a fill color to use:

Once you click OK, each of the rows that contain a “Yes” in the Passed column will be highlighted:

Excel highlight rows based on cell value

Each row that contains “Yes” in the Passed column now has a fill color of light green while each row that contains “No” is left unchanged.

Note that for this example we chose to highlight the rows using a light green, but you can choose any color you’d like by selecting a different color using the Format button within the Edit Formatting Rule window.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Filter by List of Values in Excel
How to Filter a Column by Multiple Values in Excel
How to Count Rows with Value in Excel

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories