Conditional Formatting

Posted on 2011-10-17
Last Modified: 2012-06-27
I am trying to set a conditional format whereby if Column A in my table contains the word "NO" then the entire row is highlighted red... problem I am having is I can only get a single cell to be highlighted red rather than the entire row.

Question by:recycleaus
    LVL 50

    Accepted Solution

    You need to apply conditional formatting to all columns

    I deleted the existing conditional formatting then I selected the whole table A4:Q4 and applied conditional formatting with this formula


    Note only one $

    Now it should work - see attached

    regards, barry
    LVL 50

    Expert Comment

    by:barry houdini
    Sorry, I said "I selected whole table A4:Q4" - I meant to say "I selected whole table A4:Q19"...because that's what I did


    Author Comment

    Thanks for that... knew it was something simple!

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Detect file exist or not 3 40
    Third Sunday of the Month 10 50
    IF OR formula Excel - multiple conditions 9 40
    Excel 2010 question 3 23
    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    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…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    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…

    729 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