Change to cell background colour depending on value in a different cell in New Google Spreadsheets
google-sheets, gs-conditional-formatting
Solution
Nice that you mentioned, you are using new Google Spreadsheet.
Select A2
Format - Conditional Formatting
From the dropdown select `"Custom formula is"` and type `=A1<A2` tick `Background` and select the color red color. Change `Range` as requried.
Click +Add another rule
From the dropdown select `"Custom formula is"` and type `=A1>A2` tick `Background` and select the color green color. Change `Range` as in Rule 1.
Here is a link
Problem
I'd like to have the cell background colour change to green or red depending on what I type in the cell, and I would like this to be dependent on the cell above. So if the A1 cell says 7 and I type 8 into A2 I want A2 to have a red background. If the A1 cell says 7 and I type 6 into A2 I want the background colour to change to green. So, to recap, if A2 is less than or greater than A1, I want A2 to change to green or red. And I want to have this happening throughout the entire A column. If A3 is higher or lower than A2 I want A3's background colour to change to red or green but I'm not bothered about A3 being higher or lower than A1, if you know what I mean? - I only want the cell to change colour based on the cell directly above it. I am aware of conditional formatting and the option to use formula and also the <> options but I just can't seem to get it to work? I'm using the new Google spreadsheets. Thanks In Advance Philip.