Changing the font color is one way to represent the selected item in the drop-down. You could just as easily use the Fill property instead. How to change the color of a cell in an Excel drop-down ...

Click on a cell to highlight it. Select the Data tab from above the Ribbon in your Excel spreadsheet. Next up, click the Sort button, and right away a window will appear. From the newly loaded ...

Variations You can use GET.CELL to return a lot of information. The value we used, 38, returns a cell’s fill color. For instance, to sum the values, you’d use 5 instead of 38 when creating the ...

Excel allows defined functions to be executed in Worksheets by a user. Instead of a formula based on the color of a cell, it is better to write a function that can detect the color of the cell and ...

There is an easier way. Highlight cell a1:g7 and set conditional format style to 3-color scale. Set minimum number to -1, midpoint number to 0, and max number to 1. Much quicker method.