Use different cells for conditional formatting on same row

Posted on 2012-08-17
Last Modified: 2012-08-27
In a cell I have a drop down list of either Yes, No or ? (C2).  Depending on which of these is chosen, that entire row is highlighted a different color.  (I only used two conditional formatting for this because 'NO FILL' is a color too, white)  I want to be able to also look at cell F2 and if it = YES, I want that entire row to be bold.

Trouble is, that if cell C2 = No and the row turns grey, AND cell F2 = Yes, nothing happens for that condition.  It is like conditional format can only do one format per row.
Question by:John Desselle
    LVL 13

    Assisted Solution

    Yes, only 1 condition can be met. I see 4 test cases, it'll use which ever one tests true first.

    What you can do is over in col J use the following formula

    Open in new window

    IF val=0 then not grey or bold.
    if val = 1 then grey not bold
    if val=2 then not grey but bold
    if val=3 then grey and bold

    You can then either hide that column, or set its forecolor to be white to effectively hide it.

    Author Comment

    by:John Desselle
    cool formula, but how would you use this to conditionally format the cells?

    Author Comment

    by:John Desselle
    oh, I get it, the first entry in the list is just no formatting, then use the other three.  COOL
    LVL 13

    Accepted Solution

    Actually, yes thats true.  You can leave the first conditional off, as it would be default. Check for 1,2 and 3.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now