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
769
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