| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
User defined function detects font colour
A calculate event is not triggered by a format change BUT
conditional formats get executed by every screen refresh done on the part of the screen they are formatting, and you can use UDFs in conditional format conditions ... regards Charles ______________________ Decision Models FastExcel 2.2 Beta now available www.DecisionModels.com "WeedOutSpammers" wrote in message ... However, when the font colour is changed the worksheet does not recalculate. Is there a way a recalculate can be forced on a format change? If the cell is edited (or go into edit mode but do not change anything) then return is pressed then everything works fine. Who has a solution or is this just a free suggestion to Microsoft which would simply add another dimension to the Worksheet for applications like schedule creation for more than one supplier. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Color a result cell in a user defined function | Excel Discussion (Misc queries) | |||
| Creating my own user defined function help statements | Excel Worksheet Functions | |||
| User defined charts- font size too small | Charts and Charting in Excel | |||
| how to move user defined function | Excel Worksheet Functions | |||
| Function to return colour of formatted cell | Excel Worksheet Functions | |||
Hybrid Mode
