% Attainmnet Cell Color Cange

[jswillcox]

I would like to set a cell to automatically change to a custom color when a number range is reached for comissions tracking.

Example

Quota:
C12 = 100 (desired Number in D12 is 0 or lower)

Gap:
D12 = Formula used [=sum(C12-I15)]

Items Sold:
I15 = items sold

I would like to use 3 custom colors

When I am less that 80% to quota I would like D12 to be Custom Color 1
When I am 80% to less than 100% I would like D12 to be Custom Color 2
When I am 100% or greater I would like D12 to be Custom Color 3

Is this even possible? Thank you so much for your help!

 

[ashliiii]

Use conditional formatting to set three different colors by adding three rules.

Home tab -> Conditional formatting -> Top/Bottom rules