Conditional Formatting to change Field Contents

Might it be possible to have CF whereby if a condition in Field A is met then the contents of Field B change to a defined value?


You could apply conditional formula to Field B.

I was hoping to be able to do this via Conditional Formatting rather than Conditional Formula as the latter requires a local formula recalc on the sheet if another another user of the sheet changes an entry.


Conditional formatting is a front end structure, it will only have an effect on browser side. Changing value will impact on back end which the value actually saved in database, I’m afraid it’s really difficult to accomplish this.

Yes, I can see why. Thanks anyway Hank.