I'm using Google spreadsheet and working on a daily dashboard. What I need is to change the background color of cell B5 based on the value of another cell - C5. If C5 is greater than 80% then the background color is green but if it's below, it will be amber/red.
Is this available in google spreadsheet functions or do I need to insert a script. Thanks a lot