How to add a new colour scale in conditional formatting?

LRATOZ

Board Regular
Joined
Aug 17, 2014
Messages
57
Office Version
  1. 2016
Platform
  1. Windows
Hi,

I am desiging a dashboard in Excel 2016 that will show the temperatures for each month. Something like this:

1624504820329.png


Now as you can see I applied a standard Conditional Formatting scheme, which works great.
However, I want to apply a colour scheme as what is used within the Australian Bureau Of Meteorology so that my colour scheme is the same as what is used by the BoM.

I want to apply following colours for each temperature value.
Here's the table containing the official colour codes:

1624505005351.png


I have tried to design different rules for each graph but it's a tedious process and if I want to apply the same colour scale to other graphs then I will need to start all over again.
Basically, what I want to do is: Go to Home - Conditional Formatting - Colour Scales and then pick my own variant that incudes the colours as used by the BoM; Is this feasible?
Many thanks in advance for your help!
Cheers,

Luke
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,890
Office Version
  1. 365
Platform
  1. Windows
Hi Luke,

Have you tried any of these features or created a custom colour range here?

Try this link Themes in Excel or YouTube has videos on creating your own colour theme in Excel 2016
 

Attachments

  • Image.jpg
    Image.jpg
    23.3 KB · Views: 0

LRATOZ

Board Regular
Joined
Aug 17, 2014
Messages
57
Office Version
  1. 2016
Platform
  1. Windows
Hi Luke,

Have you tried any of these features or created a custom colour range here?

Try this link Themes in Excel or YouTube has videos on creating your own colour theme in Excel 2016
Hi JackDanice,

Your suggestion is about changing the theme colours in Excel. However, my question was in relation to adding a colour scale under Conditional Formatting.
Thanks for your suggestion anyway.
Cheers,
Luke
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,237
Messages
5,768,967
Members
425,507
Latest member
AndreaWorkPlace

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top