Since the value of cell B2 is 47, greater than 20, the cell is highlighted in green. This keeps the default formatting color (green), but you can change it if you want by clicking on the Fill color icon.
Create Conditional Formatting in a Single Cell
Let’s first show how to create a conditional formatting rule for one cell. You can also apply conditional formatting to multiple rows in Google Sheets in the same ways shown above. Apply Conditional Formatting to Multiple Rows in Google Sheets The output is exactly the same as in the previous section: All cells with numbers greater than 20 are highlighted.
The first option is to use copy-paste to copy only formatting to other cells. Next, we’ll show how to apply this formatting to other rows in the range.
Say you have the list of numbers below in Column B.Ĭreate Conditional Formatting in a Single Cellįirst, create a rule that highlights cell B2 in red if its value is greater than 20. Let’s show first how to create a conditional formatting rule for one cell. If you have conditional formatting in one cell in Excel, you can apply it to multiple rows in a few different ways. In this article, you will learn how to apply conditional formatting to multiple rows in Excel and Google Sheets.Īpply Conditional Formatting to Multiple Rows