Using Conditional Formatting Color Scale

I don't think that this is a programming question as this doesn't need a custom formula. However, to answer your question this is how you do it.

• Create Conditional Formatting.

• Click on the Color Scale Tab.

• Select the Range of Data to Apply this.

• I would suggest adjusting it via percentile due to the nature of your data.

• Then Apply the Color you want to be applied.

Sample Output

Note: You can adjust the gradient by adjusting the mid point.