Closed Thread
Results 1 to 2 of 2

Conditional Formatting for Multiple Values

  1. #1
    Registered User
    Join Date
    10-24-2005
    Location
    Lake Forest, CA
    MS-Off Ver
    2007
    Posts
    56

    Question Conditional Formatting for Multiple Values

    I see how to set conditional formatting for one name, how do I set it for multiple values?

    Column A contains one of three names: Teri, Linda, Evelyn (Each name is repeated, randomly, through the column)
    Column B is a variety of Categorys (Some text, some numeric, all different)

    Cell A2 = Teri, I want cells A2 and B2 to be Orange, Accent 6, Darker 50% Font and Orange, Accent 6, Lighter 80% Fill

    A3 = Linda, I want cells A3 and B3 to be Dark Blue, Text 2, Darker 25% Font and Aqua, Accent 5, Lighter 80% Fill

    A5 = Evelyn, I want cells A5 and B5 to be Olive Green, Accent 3, Darker 50% Font and Olive Green, Accent 3, Lighter 80% Fill

    I would like to format both columns so that as we add entries, both columns will color code according to the name in column A.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887

    Re: Conditional Formatting for Multiple Values

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    http://www.excelforum.com/excel-gene...le-values.html

    Thread Closed.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1