+ Reply to Thread
Results 1 to 1 of 1

highlighting based on conditions

  1. #1
    Forum Contributor
    Join Date
    05-09-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2016
    Posts
    543

    highlighting based on conditions

    I can not figure out why only the color index 5 and 8 are working in the example- (1). To tun it say "no" to the initial prompt that comes up and select 1 from the dropdown in A2. Before some additional functionality was added it was called TestBook and that highlighted appropriately.

    There are 4 steps that will populate the classification (iclassification) column - not every step will have data in it:

    clinvar step
    This step is the priority step and if there is data in this column (iclinvar) then that data is used to classify and highlight accordingly.

    common step
    If there is data in this column (icommon) then that data is used to classify and highlight accordingly.

    inheritance step
    If there is data in this column (iinheritance) then that data is used to classify and highlight accordingly.

    gender step
    If there is data in this column (igender) then that data is used to classify and highlight accordingly.

    There are 6 classifications (benign, likely benign, unknown, pathogenic, likely pathogenic, and untested) that will result from the 4 steps above and a specific row highlighting as well. It’s a bit difficult to explain, but in TestBook all the different scenarios are there and that seemed to work. Thank you.
    Attached Files Attached Files

+ 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. Highlighting row based on the date
    By mamuka12 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2013, 02:22 PM
  2. [SOLVED] Highlighting a cell when specific conditions met
    By jpsprack in forum Excel General
    Replies: 5
    Last Post: 07-05-2012, 06:22 PM
  3. Highlighting based on dates
    By MDG_7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2011, 12:22 PM
  4. Highlighting certain conditions
    By Climaxgp in forum Excel General
    Replies: 3
    Last Post: 10-16-2009, 04:44 AM
  5. highlighting a row based on cell value
    By Castarmax in forum Excel General
    Replies: 4
    Last Post: 05-06-2009, 05:24 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