Results 1 to 3 of 3

Showing Combo Box Numerical Results as Text.

Threaded View

  1. #1
    Registered User
    Join Date
    10-02-2012
    Location
    Camarillo, California
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Showing Combo Box Numerical Results as Text.

    I am trying to create an "IF" function in a cell to display text based upon the numerical result of a Combo Box. If I can get an answer for my example I can complete the rest of the worksheet.

    I have a combo box in Cell H10 that is cell linked to X10. The Input Range is X1 to X3. This shows up in my drop down list as I want it. The results in X10 are 1,2,& 3.

    I then wrote an "IF" formula I thought would work to show the results of the numbers as "blank", "PASS" or "FAIL" in cell G10.

    I then gave the cell conditional formatting to make the text white, green or red based on the answer.

    I had it working and my system crashed and I cannot get it working again. Please help!
    Attached Files Attached Files

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