I have created a Google spreadsheet. It has actual values and calculated values. I want the background to be green if the calculated value is less than the actual value and red if it is more.
It's a pain to individually format each cell and pasting the conditional formatting is not working as I expect. Is there an easier way?
Here's what I managed to do so far.