Hi Shiva Pillai,
You would need to write a condition for the color scheme and assign what range falls into the appropriate bucket.
I have created a sample workbook and attaching the same here its in version 10.4,Hope this helps.
PS:-I have just taken a random range just to display how the output would look like.
BG Color.twbx 16.7 KB
Thanks very much for the response. I will try this and get back to you.