I tried changing the colours and updates were automatic. Wonderful!While testing my response to your last question I noticed that once a colour has been changed it is difficult to get the sheet to re-calculate, so I've made a very small tweak to the user-defined function. Now, once you've changed a colour it should update automatically, but if it doesn't you can make it recalculate by pressing F9 on the key board.
Alteration in attached.
Thank you very much