Conditional formatting with an AND statement

Hello,

I'm working on a template and I want the cells in the body of a table to highlight if both of the below parameters are met.

the row label in column A = "Hello"
the cell value > 10

Right now I have the formula in the conditional formatting as =IF(AND($A$1="Hello",B1>10),TRUE,FALSE)

If I copy the format down and change $A$1 to $A$2 and so on, I can then copy it across so it works for the rest of the sheet but I run into a problem if I need to add additional rows.

Thanks again.

You don't need the IF in conditional formatting
Conditional formatting is an IF by default already.
You just need a function that returns TRUE or FALSE
AND returns a TRUE or FALSE result by itself.

So you can just do
=AND($A$1="Hello",B1>10)


And you don't have to put it in one cell, then copy it down and adjust the references each time.
Instead, highlight the ENTIRE range you want it applied to
And enter the formula relative to the top/left cell of the range you highlighted.
You just need to make the Row Reference 'relative' instead of absolute (remove the $ from the Row)
Change $A$1 to $A1

=AND($A1="Hello",B1>10)


Hope that helps.

Thanks,

I thought that I had tried that before but there must have been something else off with my formula. Works now.

Thank you