[Last Call] Learn how to a build a cloud-first strategyRegister Now


Excel 2010 Conditional Formatting assistance

Posted on 2011-10-19
Medium Priority
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
  • 3
  • 2

Expert Comment

ID: 36997330
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.

Accepted Solution

The_Antman earned 2000 total points
ID: 36997338
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

ID: 36997357

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.
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Expert Comment

ID: 36997421
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 42

Expert Comment

ID: 36997864
@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

ID: 37021773
Thanks for the assist.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

825 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