Excel uses conditional format to add color to a whole line of qualified cells?

Use the conditional format, as shown in the figure below, and fill the numbers greater than 15 with green:

Select all worksheets (click on the cell area in the upper left corner and the small box position at the beginning of the above picture);

Start tab, conditional format, new rule.

"use formula to determine the formatted cell", and the formula reads "= $ c1>; 15 ",click Format to set the fill color, and then click OK. It should be noted in this step that the formula is an absolute reference column "$C 1".

The first line in the figure is also filled with color, because in excel, the text is larger than the number, so it is also filled with color. If you don't want to fill the first row, you can delete the conditional format of the first row by selecting the first row, clicking the penultimate clear format in the conditional format drop-down menu above, and then selecting the format of the selected cell.

What are the quality control points of earthwork filling in water conservancy and hydropower projects?

Humorous jokes when you are lovelorn.

Zuiwei plastic surgery

Is there a suitable doctor's recommendation for liposuction of thigh in Kunming Dream Plastic Surgery? Are there any cases of failure?

What is a crane safety device?

A female bus driver in Xi'an, Shaanxi Province has become famous on the Internet because of her good looks. Does she want to become an Internet celebrity?

The correct way to maintain wooden exterior walls

Introduction of Kunming dog strain with black back

Is it expensive to do breast augmentation with prosthesis?

Excuse me, what are the best methods for boys' masseter muscle? In particular, the masseter muscle is particularly large and feels a bit like a square face.