Custom format based on other cells value

**im_kaushal** · 02-04-2012, 12:52 AM

Dear All,

Is it possible to create a custom format based on the value available in other cells.

As in the below mentioned example.

Col A Col B
Row 1 Currency Amount
Row 2 Dollar $25.00

If I change the Value of A2 from 'Dollar' to 'Pound', then B2 should Display £25.00. It should be done in custom format only so that i can use these numbers for further caculation. I am not looking for a solution using macro for this.

Any help is highly appreciated!

Many thanks,
Kaushal, India

**dilipandey** · 02-04-2012, 01:10 AM

Hi Kaushal,

If not Macro, are you open for formula?

Regards,
DILIPandey

<click on below 'star' if this helps>

**im_kaushal** · 02-05-2012, 05:17 AM

Hi Dilip,

Thanks for the response.

I can not use a formula and looking a custom format to display the result.

Rgds, Kaushal

**dilipandey** · 02-05-2012, 07:46 AM

Hi Kaushal,

I believe custom format will not look outside the cell in selection, but not sure. Try and search more on this. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>