Excel: calculate efficiency from times

[McGraw]

Good morning.

I’ve completely removed my initial query and replaced it with this one:

I want to conditionally format cells so 0% is bright red, 100% is normal green. Anything inbetween graduates from red to green and above 100% the green gets brighter to a max of say 200%.

Any ideas? Thank you

 

[james.miller]

look at 3 colour scale conditional formatting. set the minimum to 0 [number] and red, midpoint to 1 [number] and green and maxmium to 2 [number] and whatever other shade of green you need. This is assuming your percentages are stored as decimals where 100% = 1 etc.

 

[Donnie Fisher]

SomeCell.Interior.Color = RGB(150, 220, 90)

Would suggest that the cells can be given RGB values, so if you have an efficiency factor value, you could use that to change the value of the RGB.

From this web page...

https://stackoverflow.com/questions...ynamically-according-to-a-rgb-value-stored-in

The thing you have to factor is how each r g b value will have to change depending on the value. I.e. they won't all simply run fro. 0 to 255