Conditional formatting - changing values [Closed]


I am looking for a conditional formatting or/and formula to apply the following:

-in a selected area (column, row, worksheet) values should automatically be changed from A to 133, B to 175, C to 234, D to 343.

I have found similar posts where similar conditions converted to colours etc. I am able to manage this but somehow the numbers just don't work for me.

Can anyone help me with a smart and good choice please? I seem to be quite lost, so I would appreciate if you can explain it well :)

Thank you.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!