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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

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

20 responses
Excel function question
1234ah -
ac3mark -

3 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses