Conditional Cell Category

[one third]

Is it possible to make a cell's category conditional on the value in
another cell?

I would like to have a cell display its value as a currency if the
cell before it says "Monthly", and as a percentage if the cell before
it says "Annual".

I am working in Excel 2003.

Thank you, Trey ~

 

[FSt1]

Is it possible to make a cell's category conditional on the value in
another cell?

I would like to have a cell display its value as a currency if the
cell before it says "Monthly", and as a percentage if the cell before
it says "Annual".

I am working in Excel 2003.

Thank you, Trey ~

hi
afraid not. currency and percent are number format and CF does not
allow for number formats. you might get by with a worksheet change
macro to achieve what you want but you would have to provide more
details such as what column. the percentage thing is a puzzler too.
how does that fit in? would you have to do some math to get the
percentage?

regards
FSt1

 

[Matt Richardson]

hi
afraid not. currency and percent are number format and  CF does not
allow for number formats. you might get by with a worksheet change
macro to achieve what you want but you would have to provide more
details such as what column. the percentage thing is a puzzler too.
how does that fit in? would you have to do some math to get the
percentage?

regards
FSt1

There's a similar post and some ideas on how to implement using VBA
here:-

http://www.mrexcel.com/forum/showthread.php?t=28315

HTH

Matt,
http://2toria.com
http://teachr.blogspot.com

 

[one third]

There's a similar post and some ideas on how to implement using VBA
here:-

http://www.mrexcel.com/forum/showthread.php?t=28315

HTH

Matt,http://2toria.comhttp://teachr.blogspot.com- Hide quoted text -

- Show quoted text -

Thanks everyone for your feedback on this.

Trey ~