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!
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!