Hello I am attempting to create a macro that will take the value of one cell and change the color of the cell and include text that represents the value. For example, if the value of the cell is "10" I want the macro to change the "10" to the word "Green" in white font and fill the background of the cell to Green. I need this for 4 different scenarios.

I have attached an example below

Attached Images

Screen Shot 2018-06-29 at 11.23.33 AM.png (31.3 KB, 23 views)