Multiple client rows with finished status for every rows

**MarkHay** · 06-19-2012, 05:22 AM

Hi,

I've got a spreadsheet with a list of clients and account statuses. Each client has multiple rows and each row has a status. I want to be able to highlight the clients who has a finished status for every one of there rows...

Anyone got any clever ideas?

ExcelScreenShot.JPG
Working in excel 2003

Much thanks!
Mark

**zbor** · 06-19-2012, 05:24 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**Fotis1991** · 06-19-2012, 05:40 AM

Hi and welcome to the forum.

Highlight your range(B2:H29).

In Conditional Formatting rules, put this.

=$H2="FINISHED"

Choose color>>OK.

**zbor** · 06-19-2012, 05:42 AM

Seelct cells you want to format and write in Conditional Formatting:

=$H2="Finished"

**MarkHay** · 06-19-2012, 06:02 AM

Thanks guys!

Thats now changed the formatting for the individual rows that have a status of finished but is there a way I can get it to only flag if every row for that client is at 'Finished' in column H. I highlighted Column B, added conditional formatting and insterted the =$H2="Finished" in the formula section

Sorry I'm liking being a divvy, really appreciate the advice!

**zbor** · 06-19-2012, 06:14 AM

Select only data in B column and write above formula

**Fotis1991** · 06-19-2012, 06:14 AM

You must Highlight range B2:H29(Not only B2:B29), and then put formula...

If you can not handle this, upload your sample workbook ...

**MarkHay** · 06-19-2012, 10:02 AM

Had to rejig a couple of columns as one of the references was a formula field. removed headers row, highlighted columns A & B and applied the condition formatting (changing the H ref to B). doesnt seem to be quite working as you'll see from the attachment, it does work for 90186 but others are being highlighted incorrectly. thoughts?

If either of you fancy a beer in Edinburgh, I'll buy. Might be a trek though..

**zbor** · 06-19-2012, 10:07 AM

As I can see, all data with Finished is highlited

**MarkHay** · 06-19-2012, 10:16 AM

True, but I need to see only the clients who have all their rows at finished, e.g. 90150 still has 6 rows to be completed before I would want it flagged. Basically need to be able to identify the clients whos cases can closed :s

Am I being too hopeful?

Sorry!

**Fotis1991** · 06-19-2012, 10:52 AM

...Am I being too hopeful?

I don't thing so....

Take a look to the small example(I can not use ZIP, in the PC that i am now)

Is this works for you?

**MarkHay** · 06-19-2012, 11:02 AM

ooh, thats shiny! totally see your working so then I could just add an If F1=G1 display Close?

**Fotis1991** · 06-19-2012, 11:08 AM

You can just type in CF rules, F1=G1, but i think that don't need to use helpers columns. My formula in Conditional formatting rules, gives you the result that you need WITHOUT, these columns.

Try to erase these 2 columns and you'll see that your result is same as before...

**MarkHay** · 06-20-2012, 09:18 AM

Thanks Fotis, I've tried copying your working across to my main sheet but it doesnt seem to want to play, column F keeps reverting to #NAME? when I touch it. I do rerally like the way you've laid it out though becuase I would love to be able to add a flag in a field so I could auto filter and only see the ones I can close rather than scrolling through

any ideas?

**Fotis1991** · 06-20-2012, 09:23 AM

Hi

Strange...

Can you upload a small sample of your real Sheet?

**MarkHay** · 06-20-2012, 09:38 AM

is the zip i uploaded yesterday any good?

**Fotis1991** · 06-20-2012, 10:19 AM

Ι INSIST that you do not need these 2 columns....

Although these, see the file...

Multiple client rows with finished status for every rows

LinkBack

Thread Tools

Rate This Thread

Display

Multiple client rows with finished status for every rows

Re: Help guru required!.. please

Re: Multiple client rows with finished status for every rows

Re: Multiple client rows with finished status for every rows

Re: Multiple client rows with finished status for every rows

Re: Multiple client rows with finished status for every rows

Re: Multiple client rows with finished status for every rows

Re: Multiple client rows with finished status for every rows

Re: Multiple client rows with finished status for every rows

Re: Multiple client rows with finished status for every rows

Re: Multiple client rows with finished status for every rows

Re: Multiple client rows with finished status for every rows

Re: Multiple client rows with finished status for every rows

Re: Multiple client rows with finished status for every rows

Re: Multiple client rows with finished status for every rows

Re: Multiple client rows with finished status for every rows

Re: Multiple client rows with finished status for every rows

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions