How to change the color of the entire row that meets the condition in Excel

How to change the color of the entire row that meets the conditions in Excel

Assume that when A1=A2, the background color of all cells in the first row turns pink Color:

1. Select the first row and click "Conditional Formatting" > "New Rule";

## Recommended learning:

Excel Basic Tutorial

2. In the "Select Rule Type" in the "New Format Rule" dialog box that pops up, select: Determine the cells to be formatted based on the formula, and select Enter the formula: =$A1=$A2 in "Formula Value Format", click "Format" to select the fill color;

3. Verify the result

1) When A1 and A1 are equal to 10, the first line changes color at the same time

2) When A1 is not equal to A2, the format of the first line is eliminated at the same time, and the default is none Color state;

#3) When A1 equals A2 again, the first row changes color simultaneously again.

For more Excel and related tutorials, please pay attention to

PHP Chinese website!

The above is the detailed content of How to change the color of the entire row that meets the condition in Excel. For more information, please follow other related articles on the PHP Chinese website!