Conditional Cell Category

  • Thread starter Thread starter one third
  • Start date Start date
O

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 ~
 
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 ~
Click to expand...

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
 
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
Click to expand...

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
 
Back
Top