MsCrystal1
New Member
- Joined
- Jun 30, 2015
- Messages
- 6
I'm stumped I have multiple rows and columns that are independent of each other. I need to setup a legend that's automated with three colors.
The spreadsheet is setup like this ...
<tbody>
</tbody>
Now the legend would need to function so that Goal/Actual for set the following colors
<tbody>
</tbody>So C2/C1 has to be evaluated against the above criteria
.2/.1=.5 which means it should be red I need the color to apply to C1 and C2
and then the same for D2/D1, E2/E1, F2/F1 and G2/G1 then move down to D5/D4, E5/E4
I hope this makes sense ... I have no clue where to start although it seems like this should be fairly easy to figure out.
Any assistance is appreciated.
The spreadsheet is setup like this ...
A | B | C | D | E | F | G | H |
S | L | H | W | SD | V | ||
1 | Goal | .2 | .3 | .3 | .4 | .6 | .6 |
2 | Actual | .1 | .4 | .3 | .5 | .7 | .6 |
Total | |||||||
4 | Goal | .4 | .5 | .7 | .4 | .4 | 0. |
5 | Actual | .5 | .5 | .3 | .10 | .5 | .10 |
Total |
<tbody>
</tbody>
Now the legend would need to function so that Goal/Actual for set the following colors
Green | Meeting 90% or more of 2014 goals |
Yellow | Achieve 60% to 89% of 2014 goals |
Red | Achieve less than 60% of 2014 goals |
Gray | No goal |
<tbody>
</tbody>
.2/.1=.5 which means it should be red I need the color to apply to C1 and C2
and then the same for D2/D1, E2/E1, F2/F1 and G2/G1 then move down to D5/D4, E5/E4
I hope this makes sense ... I have no clue where to start although it seems like this should be fairly easy to figure out.
Any assistance is appreciated.