Cell Color

[craig2525]

I have a workbook that gives me a number depending on cell color using Define Name. I named it GetColor. I used a previous post in MrExcel to do this. When I change the color, the number does not change automatically. What am I doing wrong?

=GET.CELL(38,Sheet1!$B$2)

This is what I am using for the name GetColor.

=GetColor

This gets me the number of the color of the adjacent cell.

 

[Kenneth Hobson]

Color changes do not trigger a calculation event. Use calculate or change something to get it to update.