I am trying to set up a formula which will change the text colour in one cell
if another one is changed to "yes", if it says no then it will be unchanged.
Can this be done and if so how?

Thanks