- Apply Conditional Formatting Across Several Cells
- How to apply @ in laptop - Guide
- Conditional formatting if another cell contains - Excel Forum
- Apply the moderate effect smartart style - Guide
- Excel formula to change cell color without conditional formatting - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
You are right, there is an easier way.
It starts with the formula you use. The AND part is unnecessary, but more importantly remove the dollar symbol in front of the 2. With the dollar symbol in place, the formula will keep referring to cell A2, even when applied to other cells, or in your case, rows.
Your formula should look like this:
Now over to the applied range. Since we now freed the number 2 of its dollar symbol, you can select the entire row and drag it down as far as needed. In your case it's probably faster to just adjust the formula:
By the way, how do you like Excel 2207? I'll probably (you never know) won't live long enough to experience it ;)