Travel1 min ago
Hidden Excel Cell Value
2 Answers
I wish to create an average risk score matrix in Excel.
The cells will be coloured from Red through to Green, with a text description in each cell.
Is there a way of giving each of these differing coloured cells a hidden value that, when there is a number of them, an average value of all cells can be calculated using the Editing option?
Thank you
The cells will be coloured from Red through to Green, with a text description in each cell.
Is there a way of giving each of these differing coloured cells a hidden value that, when there is a number of them, an average value of all cells can be calculated using the Editing option?
Thank you
Answers
Best Answer
No best answer has yet been selected by patrickstar. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.