How to fill in excel using conditional formatting

#How to fill in excel using conditional formatting?

Recommended: "excel tutorial"

As shown in the picture:

Select columns B to E , Start--Style--Conditional Formatting, "New Rule", use the formula:

=AND($A1"",SUM($B1:B1)

Set format: Fill red.

The above is the detailed content of How to fill in excel using conditional formatting. For more information, please follow other related articles on the PHP Chinese website!