Skip to main content
Web Applications

Return to Question

replaced http://webapps.stackexchange.com/ with https://webapps.stackexchange.com/
Source Link
Community Bot
Community Bot
  • 1

I have column B with different values on different rows and I want to set a rule that , for example cell b3 turns red if the value is smaller than that of B2 and green if it's bigger. I know I need to use conditional formatting, but not sure how?

I tried the solution here (How to conditional format in Google sheets based on cell directly above it?How to conditional format in Google sheets based on cell directly above it?) but that didn't work.

So what I want to say is: "if the cell's value is lower than that of the cell above it, color red, if the cell value is higher than that of the cell above it, color green".

I have column B with different values on different rows and I want to set a rule that , for example cell b3 turns red if the value is smaller than that of B2 and green if it's bigger. I know I need to use conditional formatting, but not sure how?

I tried the solution here (How to conditional format in Google sheets based on cell directly above it?) but that didn't work.

So what I want to say is: "if the cell's value is lower than that of the cell above it, color red, if the cell value is higher than that of the cell above it, color green".

I have column B with different values on different rows and I want to set a rule that , for example cell b3 turns red if the value is smaller than that of B2 and green if it's bigger. I know I need to use conditional formatting, but not sure how?

I tried the solution here (How to conditional format in Google sheets based on cell directly above it?) but that didn't work.

So what I want to say is: "if the cell's value is lower than that of the cell above it, color red, if the cell value is higher than that of the cell above it, color green".

deleted 24 characters in body
Source Link
ale
ale
  • 52.9k
  • 42
  • 165
  • 314

I have column B with different values on different rows and I want to set a rule that , for example cell b3 turns red if the value is smaller than that of B2 and green if it's bigger. I know I need to use conditional formatting, but not sure how?

I tried the solution here (How to conditional format in Google sheets based on cell directly above it?) but that didn't work.

So what I want to say is: "if the cell's value is lower than that of the cell above it, color red, if the cell value is higher than that of the cell above it, color green".

Thanks!

Thanks!

I have column B with different values on different rows and I want to set a rule that , for example cell b3 turns red if the value is smaller than that of B2 and green if it's bigger. I know I need to use conditional formatting, but not sure how?

I tried the solution here (How to conditional format in Google sheets based on cell directly above it?) but that didn't work.

So what I want to say is: "if the cell's value is lower than that of the cell above it, color red, if the cell value is higher than that of the cell above it, color green".

Thanks!

Thanks!

I have column B with different values on different rows and I want to set a rule that , for example cell b3 turns red if the value is smaller than that of B2 and green if it's bigger. I know I need to use conditional formatting, but not sure how?

I tried the solution here (How to conditional format in Google sheets based on cell directly above it?) but that didn't work.

So what I want to say is: "if the cell's value is lower than that of the cell above it, color red, if the cell value is higher than that of the cell above it, color green".

Source Link
AnakhaS
AnakhaS
  • 21
  • 1
  • 2

Google sheets conditional formatting relative to another cell in the same column

I have column B with different values on different rows and I want to set a rule that , for example cell b3 turns red if the value is smaller than that of B2 and green if it's bigger. I know I need to use conditional formatting, but not sure how?

I tried the solution here (How to conditional format in Google sheets based on cell directly above it?) but that didn't work.

So what I want to say is: "if the cell's value is lower than that of the cell above it, color red, if the cell value is higher than that of the cell above it, color green".

Thanks!

Thanks!