CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Dan Benjamin
Dan Benjamin

Reputation: 900

Conditional Formatting on column based on other column value

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 -

Let's take the following table

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:

enter image description here

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

Upvotes: 1

Views: 180

Answers (1)

player0
player0

Reputation: 1

in Apply to range put:

B2:B

under Format cells if... select

custom formula

and in field type in:

=B2<A2

Upvotes: 2

Related Questions