Geek asks and answers

Change the background color of a cell depending on the value in another cell in new Google spreadsheets

I want the background color of the cell to change to green or red, depending on what I type in the cell, and I would like it to depend on the cell above.

So, if cell A1 says 7 and I type 8 in A2, I want A2 to have a red background.

If cell A1 says 7 and I type 6 in A2, I want the background color to change to green.

So, to repeat, if A2 is less than or greater than A1, I want A2 to change to green or red. And I want this to happen throughout column A.

If A3 is above or below A2, I want the background color of A3 to change to red or green, but I'm not worried that A3 is above or below A1, if you know what I mean? “I want the cell to change color based on the cell directly above it.”

I know the conditional formatting and the ability to use the formula, as well as the <> options, but I just can’t get it to work? I am using new Google spreadsheets.

Thank you in advance Philip.

+3
source share
1 answer

It's nice that you mentioned, you are using the new Google spreadsheet.

Select A2
Format - Conditional Formatting

In the drop-down list, select "Custom formula is"and enter a =A1<A2checkmark Backgroundand select a red color. Change Rangeas directed.

Click + Add another rule

"Custom formula is" =A1>A2 Background . Range, 1.

+8

More articles:


All Articles