In cell H3 I have a formula that calculates the average of cells C3:G3. If the value in the cell is the following, I would like the corresponding text displayed with the cell formatted in a specific color.
1-1.9 display MUST DO
2-2.9 display NEED TO DO
3-3.9 display SHOULD DO
4-5.0 display COULD DO
1-1.9 display MUST DO
2-2.9 display NEED TO DO
3-3.9 display SHOULD DO
4-5.0 display COULD DO
FacilitiesActionItems.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | |||
2 | Action Item | Strategic Value | Ease | Financial Benefit | Cost | Resource Impact | Overall Priority | Priority Rating | ||
3 | 0.00 | |||||||||
ProjectPrioritization |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H3 | H3 | =SUM(C3:G3)/5 |