Current location - Recipe Complete Network - Complete cookbook of home-style dishes - How to set the selected excel drop-down menu option to change the background color of the whole line?
How to set the selected excel drop-down menu option to change the background color of the whole line?
By selecting the data in the drop-down list, the row where the data is located is colored, and this change can be achieved by setting the conditional format. For example, I want to fill the whole line with red background color after selecting the names in the table below, so as to check the students' grades, as follows: