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 ...

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 ...

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 ...