Consulting

Results 1 to 10 of 10

Thread: Need code to change background color based on text value

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Apr 2012
    Posts
    17
    Location

    Need code to change background color based on text value

    Greetings.

    I have a Word 2007 document that I use as an audit report template. There are two columns in different sections of the document. Both columns (table heading) name is Risk Ranking. The risks can be rated using the following text values: RED, YELLOW, GREEN. As you can imagine it would be nice if after I typed the respective text value the entire cell background color would change to correspond to that text value. See attachment.

    Does anyone have any ideas they could share so that this could be performed using a macro or VB program?

    I appreciate it.

    Regards,

    Mark
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •