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 AAATom Your Own Question

AAATom
AAATom, Consultant
Category: Microsoft Office
Satisfied Customers: 468
Experience:  Master's Degree in Computer Science, 20+ years of experience
66411959
Type Your Microsoft Office Question Here...
AAATom is online now

Hi, I have created a drop down list in word 2010. In my drop

Resolved Question:

Hi, I have created a drop down list in word 2010.
In my drop down list I have several options 18 in total.
When a user selects one of the drop down choices I want the text and background colour fill to be different depending on the choice the user picks.

How can I assign a different format of text and background fill colour to the 18 options the user has?

Many thanks

Tony
Submitted: 2 years ago.
Category: Microsoft Office
Expert:  AAATom replied 2 years ago.

AAATom :

Hello and welcome to JustAnswer!

I would like to help you make the drop down list work the way you describe.

Can you, please, confirm that you want the text and background color change in the document, not in the dro down list, correct?

AAATom :

Thank you,
Tom

Customer:

Hi Tom,

Customer:

The color change will be in the drop down list

AAATom :

Hm, that is a bit of an unusual thing to do. Please give me few minutes to check it out.
Can you tell me which version of Word do you have?

Customer:

















I have 2010

AAATom :

OK, thank you.

Customer:

image of problem
Full Size Image

Customer:

I would like the background fill to be green for low risk when selected, yellow for Medium risk when selected and red for high risk when selected

AAATom :

I understand. I am checking if this can be done in Word.

AAATom :

I am not really sure this can be done but I'm trying some workarounds.
Thank you for the patience.

AAATom :

Can you, please, send me the document with the drop down?
You can upload the file to www.wikisend.com service and post here the File ID number you get there.

Thank you.

Customer:

sure will do

AAATom :

Thank you.

Customer:

I am blocked from doing that whilst connected to my work internet, but I will do it when I get home in around two hours

AAATom :

I see. I am sorry for the problem.
You can try attaching the file here in chat by using the paperclip icon.

AAATom :

It will ask for a picture but it can take several file types. Please try it.

AAATom :

OK, got the file, thank you!

Customer:

you will see there is color coding but its not correct, it covers all options you make

AAATom :

Yes, I see. I needed to see which control you used for the drop down.

AAATom :

I'm not sure this control can be manipulated though.
Please give me some more time for this.

Customer:

no problem many thanks

AAATom :

You are welcome.

Customer:

I am going home now, will you reply to my email address [email protected]

Customer:

or I will be available tomorrow to close this out with you.....

AAATom :

OK, not a problem.
You can come back to this page from your home computer (or smartphone). We are not allowed to use direct communication except as a form of additional service.

AAATom :

Or we can continue tomorrow if that is more convenient for you, no problems.
Just post here and I will respond as soon as I can.

I'll look into the problem in the mean time, of course.

AAATom :

Hello,

I have checked the available possibilities and the only way to change anything on the drop down change is by a workaround.
The workaround is a macro that is constantly run in the background. It checks whether any of the drop downs have changed and changes background fill of the changed drop down.


AAATom :

I wrote such a macro and put it in your document.
Please download it from here:

Attachment: 2014-04-08_033759_risk_assessment-mod1.zip

Full Size Image

AAATom :

The document is macro-enabled and I had to zip it to be able to attach it here - just double click the zip fiel to open it and drag the "risk_assessment-mod1.docm" file to a folder where you can open it.
You will have to enable macros for it to work - please let me know if you need assistance with that.

AAATom :

Please test the document and let me know if this is what you had in mind or if there are any issues.

Please do not rate my service until you are satisfied. I will gladly work with you further to make the document work as you need it to.

Thank you,
Tom

AAATom, Consultant
Category: Microsoft Office
Satisfied Customers: 468
Experience: Master's Degree in Computer Science, 20+ years of experience
AAATom and other Microsoft Office Specialists are ready to help you

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    23
    A+ Comptia Certified computer repair
< Previous | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    23
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    241
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERf8udkdxk/2013-8-3_15150_323738101505074393259301621172992o.64x64.jpg KamilAnwar1's Avatar

    KamilAnwar1

    Office Specialist

    Satisfied Customers:

    120
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    111
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/WI/Windowspcfix/2013-8-19_153826_ja12.64x64.jpg James K.'s Avatar

    James K.

    Consultant

    Satisfied Customers:

    110
    Technical Director of IT Company
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    56
    Bachelor's Degree in Information Technology, Microsoft Certified Professional
 
 
 

Related Microsoft Office Questions