excel - How to automatically change colors in a row if one cell in the row is not blank?

Question

For example, if J2 is not blank anymore, the whole row turns green.

I have this written down:=IF(NOT(ISBLANK($J$2)),TRUE,FALSE), and apply only to row 2. But I want to expand to the whole sheet, not just only row 2.

Answer 1

Just remove dollar sign from in front of 2 like-

=IF(NOT(ISBLANK($J1)),TRUE,FALSE)

In fact you can simply use below formula.

=$J1<>""