Changing cell formats based on another cell value

Closed
mgadrago Posts 1 Registration date Sunday February 3, 2013 Status Member Last seen February 3, 2013 - Feb 3, 2013 at 11:59 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 4, 2013 at 09:55 AM
Hello,

I was having difficulty in solving this problem. say:

I have a dropdown on A2, text1, text2, text3

when you selected text1 the format of b2 and c2 should be hh:mm:ss (12:10:01)
when you selected text2 the format of b2 and c2 sholdd be percentage (95.1%)
and so on...

is it possible to do this in conditional formatting?

Thanks in advance


1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 4, 2013 at 09:55 AM
On C2 and B2 apply the conditional format as you want. You have to go to "format" when you are in conditional format screen
0