View ROWS with filled color

**gveludo** · 06-30-2017, 11:18 AM

Hello!

I have a sheet with 6 columns and more than 25000 rows.

The first two columns have a client name and a client number. The other 4 have numbers. I have used duplicate values to mark some of the cells with color.

What I need to do is find which row has 3 or more columns filled with color and I need Excel to give me the name and number in the first two rows.

Can it be done?

Thank you!

**Mvaldesi** · 06-30-2017, 11:30 AM

Can you please provide a sample work book so folks can see exactly what you're talking about?

**FlameRetired** · 06-30-2017, 04:47 PM

gveludo welcome to the forum.

A written description leaves too much to the imagination.

An uploaded Excel workbook with data BEFORE and AFTER is helpful. It gives us context. Please don't upload pics or screenshots. No one wants to re type data.

If you are not familiar with how to do this:

To attach a file to your post,

be sure to desensitize the data
click “Go Advanced” (next to Post Quick Reply – bottom right),
scroll down until you see “Manage Attachments”, click that,
click “Browse”.
select your file(s)
click “Upload”
click “Close window”
click “Submit Reply”

The file name will appear at the bottom of your reply.

**gveludo** · 07-03-2017, 10:10 AM

I would like Excel to recognise the row with 3 filled cells and return the name of the client or its number.

I have already found a way to match a column with the numbers in my cells C, D, E and F and fill with color.

Now I need to get an alert/warning if 3 or more cells in the same row have that FILL option.

In the example I would like Excel to return "130 Mr Z".

Is it possible?