Using formatting for criteria

[mdmackillop]

Is there anyway to add the number to G5 when the formatting of the internal colour changes, as opposed to just selecting the cell??

I don't understand what you're after. What cell is undergoing a colour change, and what is causing it?