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.