Hidden Excel Cell Value

patrickstar | 15:54 Thu 19th Dec 2019 | Technology

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

prev

next

Alexa

Answers

1 to 2 of 2

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.

Can you make the font the same colour as the background of the cell.

Question Author

I can Old_Geezer and can see what your simple but clever thought process is with this! :-)

1 to 2 of 2

Do you know the answer?

Hidden Excel Cell Value

Answer Question >>

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.