Conditional formatting in Excel can format cells that meet certain conditions, so when filling the whole row with color according to the value of a column, you need to pay attention to the following two points:

First, select all the cell ranges that need conditional formatting.

Use format when referencing cells that need to be judged (such as column A).

$ A 1- means that each row is judged by column A, thus realizing "color filling of the whole row according to the value of column A".

Below is Excel.

Take 20 10 as an example to demonstrate-if the cell of column A in the sample data is "A", set the filling color of the whole row to green:

1. Select all areas that need conditional formatting, and create conditional formatting as shown below.

2, as shown in the figure below, set specific rules, pay attention to the use of the formula is

=$A 1= "A "

3. The realization effect is as follows