Previous Topic Next Topic

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 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
Counting cells containing only numbers
jutulu -
jutulu -

4 responses