+ Reply to Thread
Results 1 to 2 of 2

using Conditional Formatting on a cell with a drop down list

  1. #1
    Registered User
    Join Date
    05-20-2008
    Posts
    1

    using Conditional Formatting on a cell with a drop down list

    Please help.

    I have a cell that has a drop down list with 20 words.

    I want 5 words to highlight red, 5 words to highlight Yellow, and the remaining 10 words to highlight Green.

    Example:
    In Cell I2 I have the following words:
    Deceased, Current, Skip, Can't Find, Payment (when my client chooses either of thoses words, the cell will highlight red. if they choose, John, Cindy, Kate, Marlon, Nevaha, the cellw will highlight yellow, and soforth.

    So what i was trying to do was, click on the cell with the drop down list, click format, the conditional formatting...I will click Cell Value Is, equal to, the put Deceased, current, skip, can't find, payment, format, red, ok, ok
    dont work

    but i did try cell value is, between Deceased and Current, and both of those words highlighted Red but i want to have the other 3 words from the list highlight red.

    So I am stuck

    I want 5 words in Condition 1 to highlight red, 5 words in condition 2 to highlight Yellow, and 10 words in condition 3 to highlight green. CAn you assist.
    Last edited by Paul; 07-24-2009 at 05:00 PM. Reason: Thread moved to more appropriate forum. Please read the forum rules.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: using Conditional Formatting on a cell with a drop down list

    Formula is:
    Please Login or Register  to view this content.
    Ben Van Johnson

+ Reply to 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