Automatic update of Function return value.

I have a written a small function that returns Interior.ColorIndex.Works well except that then when I change the color of the range thefunction doesn't update automatically. I need to click in function forit to return new value.

Help appreciated!!

Function to be used in conjunction with Autofilter so sales staffindicating status of opportunity by color code easily can sort on it.