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.

player0 · Accepted Answer · 2021-01-23 21:30:14Z

2

in Apply to range put:

B2:B

under Format cells if... select

custom formula

and in field type in:

=B2<A2

answered Jan 23, 2021 at 21:30

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Conditional Formatting on column based on other column value

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related