Quote:
Originally Posted by Longshot6977
The new spreadsheet looks great Ray. I like the formatting colors too. I'm sure after I use the sheet many times, I can figure this out, but I'll ask now. Can you tell us the cutoff values you used to change a color from dark green to lighter green to light yellow to etc? And also for the right hand column (Ratings with Impacts).
I ask because I see a light green 11% as well as a yellow 11% on the sample sheet. Thanks.
|
I used the default setting for Excel's 3 color scale.
Here is Microsoft's explanation for this scale.
- Explanation: by default, for 3-Color scales, Excel calculates the 50th percentile (also known as median, middle value or midpoint). The cell that holds the minimum value is colored red.
- The cell that holds the median is colored yellow,
- and the cell that holds the maximum value is colored green. All other cells are colored proportionally.
Each factor has it's own color scale so what is light green in one factor may be a different shade of green in another factor's scale.
It's possible to set up your own scale rules but I never tried that.