AppsCare | How to add gradient conditional formatting rules in Google Sheets - AppsCare
AppsCare is a Google for Work Premier Partner in the UK and specialises in the deployment of Google Apps for Work, Google Drive for Work, Google for Education, Google Maps for Work, Chrome Devices for Work and Google Search.
google enterprise premier partner, google enterprise partner, google enterprise reseller, google apps reseller, google apps partner, google maps reseller, google maps partner, chromebooks reseller, chromebox for meetings, google maps for business, google apps for business, google apps for education, google drive for work, drive for work, google for work, google apps for work, google maps for work, chrome for work, google for work premier partner, google apps for work reseller, uk, google for work uk premier partner, google apps reseller, google apps partner
single,single-post,postid-18171,single-format-standard,ajax_fade,page_not_loaded,,wpb-js-composer js-comp-ver-4.0.5,vc_responsive

02 Apr How to add gradient conditional formatting rules in Google Sheets

How to add gradient conditional formatting rules in Google Sheets: You can now add a gradient rule to your conditional formatting, to allow you to visualise your numerical results through the use of colour gradients. 

To use conditional formatting, open up your Google Sheets page that has results you want to format.

Google Sheets

Go to Format on the menu, and scroll down to Conditional Formatting…

Conditional Formatting

This will open up a new pane on the right hand side of the window, with your conditional formatting options. The window will automatically open on Single colour format rules, but on the top you will see a tab where you can select Colour scale. Click on this to continue.

Colour scale

Next, you will need to select the data range that you want to include in the conditional formatting. This should not include any data headers.

Data range

You can now select the colour gradient you want to use for your conditional formatting. I have selected a traffic light, red-amber-green, gradient, so that I can instantly see areas that are performing well based on a customer ranking, and similarly, areas that are performing not so well.

Custom Gradient

You now need to let the sheet know the values that you want the data to be scored on. You can see here that I have added the minpoint as, as this is a low score, and the maxpoint as 5, as this is the highest score. I have also edited the colours so that the minpoint appears as red, and the maxpoint as green, as this was initially the other way round. The midpoint is left as amber.

Gradient Conditional Formatting in Google Sheets

You can now see all your data displayed with the gradient conditional formatting, which allows you to analyse and review the data based on the colour scale.

Google Sheets Conditional Formatting

If you want to delete or change the formatting, just click on the cells and you can click on the formatting you have added, or add a new rule.

Change rule


For more tips and tricks like this, check out our Google Apps Tips blog.


Claire Stead
No Comments

Post A Comment