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.