Hi,

I've created a short custom function that returns TRUE or FALSE if one or
more cells within the specified range is colored red. The function works
correctly, but if the interior color of one of the specified cells ever
changes, the function doesn't dynamically re-evaluate itself... I have to
manually force the formula cell to evaluate the function by double clicking
and hitting enter.

Any ideas?

Thanks.