How to apply conditional formatting to an entire row, not just a cell, in Excel

Mastering conditional formatting in Excel is a great way to improve your table creation efficiency. For example, you can use it to create an Excel family budget book that colors the entire row if the date is the same as today’s date.

In this article, I will show you how to apply conditional formatting to an entire row instead of a single cell.

I am on Twitter. Or Contact us here.

Operation Procedure

Assumed environment

As shown in the figure below, set the background color, etc., for each line only for the lines that are marked “Allowed” in “Column 2”.

  1. Select the entire target range.
  2. In the “Home” tab, under “Conditional Formatting”, select “Cell Highlighting Rules” – “Other Rules”.
  3. As shown in the figure, select “Use formula to determine cells to format” as the condition, and enter “=$B3=”Yes”” as the formula.
    In the “Format” field, set the format to be used when the condition is met for the entire row.
    In this case, the value “B3” is the location in the selected range where you want the condition to branch.

  4. When I clicked the “OK” button, all the lines marked as “acceptable” were formatted as expected.

How to use the Google Spreadsheet version

In this article, I showed you how to use the Excel version, but the following article will show you how to do the same operation in Google Spreadsheets. The way to use conditional formatting is quite different from the Excel version, so please check it out just in case.

How to apply conditional formatting to entire rows, not just cells, in Google SpreadsheetsEven if you don't own Excel, if you have a Google account, you can u...


In this article, I introduced a procedure to apply conditional formatting to an entire row when the specified condition is met.

It is recommended to set the selection range not only to the created table but also to all columns, etc., so that the formatting will be automatically applied when the word “acceptable” is mentioned in the future.

VOICEROID+ Tomoe Minoyasu EX Download Version

I am Japanese, and my computer is set up in Japanese. So there may be some differences in the names of the buttons and windows.

I try to keep the information on this site (tamocolony) up-to-date, but please be aware that the information on this site may not be the most up-to-date, or the information itself may be incorrect. We take no responsibility for the content of this site. If you have any questions about an article or need to make corrections, please contact us via the Contact Us page.