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.
Bookmarks