View Single Post
 
Old 06-30-2016, 07:23 AM
ikeevens ikeevens is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2016
Posts: 3
ikeevens is on a distinguished road
Default

I don't know enough about Excel.

What determines how much of the cell gets filled?

What about something like this.
If Years in Service cell = 0 the Estimated Current Value cell has no color.
If Years in Service cell = 1 the Estimated Current Value cell has 20% color.
If Years in Service cell = 2 the Estimated Current Value cell has 40% color.
If Years in Service cell = 3 the Estimated Current Value cell has 60% color.
If Years in Service cell = 4 the Estimated Current Value cell has 80% color.
If Years in Service cell > 4 the Estimated Current Value cell has 100% color.

Right now I have it if
Years in Service cell = 4 Estimated Current Value cell has gradient red to white.
If Years in Service cell > 4 Estimated Current Value cell has solid red.
Otherwise the cell has no color.

This provides a pretty good visual as to what is going out of service and what is out of service. I guess I could use different shades of red lighter to darker as things get older?
Reply With Quote