Conditional Formatting values in a column based on values in another column

Posted on 2012-09-21
Last Modified: 2012-09-21
I have an Excel spreadsheet that I want to show the values in column B in red if the corresponding value in column A is less than the value in column B.

I have the first row formatted, but when I try to use the format painter, all of the cells in column B have red font instead of just those that are less than their corresponding value in column A.

Can you help please?
Question by:rayscue
    LVL 19

    Expert Comment

    by:Ken Butters
    I updated your conditional formatting in two places... that fixed it... please see updated spreadsheet and screenshot.
    LVL 50

    Expert Comment

    by:barry houdini
    Doesn't that still have all cells in column B highlighted, buttersk?

    Format painter works OK but you have the wrong formula, you need to remove $ signs otherwise every row is formatted based on the values in row 1 (so either all rows will be formatted or none), to make sure every row is formatted based on the values in that row change formula to


    see attached

    regards, barry
    LVL 19

    Accepted Solution

    Yep.... I saw that... I tried to update my attachment in original comment but wasn't quick enough.. :)

    Author Comment

    Thanks so much!  works like a charm!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    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. …
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    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…
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    759 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

    11 Experts available now in Live!

    Get 1:1 Help Now