Excel 2010 Conditional Formatting assistance

Posted on 2011-10-19
Last Modified: 2012-05-12
Hi There!

I have an Excel Sheet. It contains 2000 Rows, 4 columns, which contain a Contact ID (Number), a contact type (Number 1 or 2) and a Display Name (Text) and a Completed (text).

I want to highlight entire rows depending on whether the Contact Type is a 1 or a 0.

I found articles explaining how to do it, but I can't seem to get it to highlight the entire rows, just the cells which meet the criteria.

The column letters are A, B, C, D

Rows Start at 3, and go to 2003


Ideally if the 4th column contained anything, it would make that row another colour so we can see easily it's completed.
Question by:networkn
    LVL 3

    Expert Comment

    Select either -
    the data range or the four columns

    On the ribbon (Home), select Conditional Formatting
    Highlight Cells Rules
    More Rules...
    >Use A Formula To Determine Which Cells To Format
    Edit the rule description
    Format values where this formula is true

    enter the formula $D3=1  (adjust as needed)

    click the Format button, select appropriate format.

    click OK.

    The row will be formatted as selected.  If you want the formatting to extend to the right, select those additional columns when you select your data range or columns.
    LVL 3

    Accepted Solution

    This is my first thread at EE.  I do not know how to edit (improve) my answer.

    When you set the appropriate format, you want to choose the FILL tab.

    Author Comment


    This is what I found to be useful in solving this problem. You answered as I was removing the question.

    I'll try your solution and see if I can solve it that way too, and if I can I'll award you the points.
    LVL 3

    Expert Comment

    That example is the same process I showed you.  Your task is accomplished In the same dialog box.  In my response, you open the dialog box at "more rules".  In your sample, you enter the dialog box at "new rule".  Either way, the process is the same.

    One of the beauties of MS Office (et al) - several doors into the same room.
    LVL 41

    Expert Comment

    @The_Antman - let me be the first to congratulate you on your first posts at E-E, and hearty welcome.

    We have an Experts thread (for all comers) you might find interesting and humorous from time to time.  When you pull up the link, just click MONITOR (right top of the OP (original post).




    Author Closing Comment

    Thanks for the assist.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Suggested Solutions

    Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
    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  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    754 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

    20 Experts available now in Live!

    Get 1:1 Help Now