How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask NewITZone Your Own Question

NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

Need Excel help - based on drop down list value - I want

Customer Question

Need Excel help - based on drop down list value - I want column to be hidden and columns need to change color
Submitted: 2 months ago.
Category: Microsoft Office
Expert:  Quiksilver07070 replied 2 months ago.

Hello, and Thank You for choosing JustAnswer.com
My name is ***** ***** I am reviewing your question now, please stand by for 1 or 2 minute for reply.

Expert:  Quiksilver07070 replied 2 months ago.

Did you want to send me the file, so i can work on it, then send it back?

Customer: replied 2 months ago.
i am sending. I have created drop down list on State column from legend tab and on legend tab , I have given on what drop down list which column should hide and which should change color of the column
Customer: replied 2 months ago.
you can create sample values to test ..... if there are no values , show it blank or hide the column,
Customer: replied 2 months ago.
how soon can you provide answer
Expert:  Quiksilver07070 replied 2 months ago.

Im un able to do it.

I will opt out for another expert to take

Sorry for the inconvenience.

Customer: replied 2 months ago.
hmmmm ok.
Customer: replied 2 months ago.
Is there anyone helping me on this
Expert:  George Sibiya replied 2 months ago.

Hi,

Welcome to JustAnswer and thank you for utilising our services.

Please give me a chance to see if I can do it within the next 30min.

Regards,

G

Customer: replied 2 months ago.
sure..thanks
Expert:  George Sibiya replied 2 months ago.

Hi,

This is not the final answer it is just to confirm if this is what you meant by Hiding J and K.

Check by selecting Deployed and something else in A2 of the Main Table tab and see what happens in J2,K2,L2 and M2

If say we select "Deployed" in A2 and hide the entire J and K columns, there would be a conflict if something else other than Deployed is selected in A3 as that would mean J and K should not be hidden.

Please advice on the exact behavior that you want.

Regards,

G

Customer: replied 2 months ago.
You are correct .. if we select only deploy ...J and K columns need hide and other colum L and M column color should change
and if any other choice is selected other than deploy ..we need to see all the columns as usual.
Customer: replied 2 months ago.
I am not able to download the file you attached.. can you please upload again
Expert:  George Sibiya replied 2 months ago.

Ok. The system does have problems sometimes I'll put it on dropbox in just a moment

Expert:  George Sibiya replied 2 months ago.

Please try this link http://wikisend.com/download/297566/table+filter.xlsx

Customer: replied 2 months ago.
I don't see a drop down list and nothing has been done on it... ??
Expert:  George Sibiya replied 2 months ago.

Ok I'll take screen shots

Customer: replied 2 months ago.
I am not getting answer as needed. Please cancel this question and refund me back