+ Reply to Thread
Results 1 to 5 of 5

Conditional formatting with combo box

  1. #1
    Registered User
    Join Date
    07-26-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Conditional formatting with combo box

    Hi everyone,

    I have a combo box with the below list inside, I have a single cell that will display the results of whatever I choose in the list I click on, the following formula is in this cell(
    Please Login or Register  to view this content.
    ) (many thanks go to Andrew R for this formula). The problem i am having is that i want to conditional format the cell that displays the values to white if blank, Green if 0, and red if more than zero, i think the problem i am having here is because of the multiple formats that can be displayed in the cell.

    No Of Quarantined Incidents
    No Of Units Quarantined
    No Of Bins Quarantined
    Total Cost Quarantined
    Average Units Per Incident
    Average Bins Per Incident
    Average Cost Per Incident

    Thanks you very much for your time and effort.
    Last edited by rbi123; 07-29-2013 at 08:42 AM.

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

    Re: Conditional formatting with combo box

    To attach a Workbook
    (please do not post pictures of worksheets)
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"

    ------------------------------
    Please edit post #1 and use code tags [B][NOPARSE][CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE][/B] for the formula instead of embedding in the the text.
    Last edited by protonLeah; 07-28-2013 at 08:11 PM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-26-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Conditional formatting with combo box

    Hi Proton Leah,

    I cannot upload the worksheet, I have cut out everything I can bit its still to big (1.17mb).

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

    Re: Conditional formatting with combo box

    O.K., on re-read, it seems that you have only two types of entries:
    Total/Average cost in pounds () formatted as text or,
    Number of... in digits formatted as text. Therefore, try:

    Red Fill formula
    Please Login or Register  to view this content.
    Green Fill formula
    Please Login or Register  to view this content.
    I.e. just replace any "" with nothing and convert the remaining textstring to a number to test.
    Attached Files Attached Files
    Last edited by protonLeah; 07-28-2013 at 09:02 PM.

  5. #5
    Registered User
    Join Date
    07-26-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Conditional formatting with combo box

    Hi ProtonLeah,

    Brilliant!! Works a treat, thanks you very much for your time and effort - it's appreciated!! Take care

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting based on Combo Box Selection
    By CaddyMatt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-23-2012, 09:07 AM
  2. Combo Box Formatting
    By Jazzy Max in forum Excel General
    Replies: 3
    Last Post: 09-24-2009, 07:06 AM
  3. Conditional Combo Box
    By smowen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-05-2009, 03:27 PM
  4. Conditional Combo Bax
    By mjwhite81 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2007, 07:01 PM
  5. [SOLVED] combo box formatting
    By ynissel in forum Excel General
    Replies: 0
    Last Post: 07-25-2005, 01:05 PM

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