google sheets - Conditional Formatting on column based on other column value

Question

I am trying to build a simple conditional formatting that will allow me color a cell value if its value is below another cell's value in the same row.

For example -

As we can see, In Rows 2 and 5 the value of column B was lower than the value of column A and therefore it turned green.

I understand how to do a static conditional analysis such as this one:

However my goal is to apply this on the entire column and not row by row.

question from:https://stackoverflow.com/questions/65863435/conditional-formatting-on-column-based-on-other-column-value

Answer 1

in Apply to range put:

B2:B

under Format cells if... select

custom formula

and in field type in:

=B2<A2