Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic evaluation of custom worksheet function
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic updating of a rollup worksheet when a new worksheet is a | Excel Worksheet Functions | |||
Need help with custom function that deals with times | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel |