Colour change does not trigger any sort of recalculation.

You could add Application.Volatile to the start of the UDF, but this will
only recalculate when something else on the worksheet forces a
recalculation, such as another function being affect, or a hard recalculate,
Alt-F9.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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.