Conditional formatting question

**dumediat** · 07-26-2012, 10:56 PM

Good evening everyone,

In my excel spreadsheet, I have a column "Account Number" and a column "Used." What I would like to do is, if the "Used" column contains '1' it will look at the Account Number in the same row, then highlight that Account Number and all matching Account Numbers below it. Is anybody able to help me write a function to do so?

Thanks in advance for any help!

**dilipandey** · 07-26-2012, 11:57 PM

Hi dumediat,

Welcome to the forum.

and all matching Account Numbers below it

Do they also need to have 1 in the same row under "used" column?

Regards,
DILIPandey

<click on below 'star' if this helps>

**dilipandey** · 07-27-2012, 12:08 AM

Hi dumediat,

See the attached file and let me know if this helps you.
Conditional formatting -matching records.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

**TonyB51** · 07-27-2012, 12:46 AM

Hi,

I have approached this slightly differently, on the basis that you are only using "1" against the first instance.

I would be interested to know if the "1" identifier is input manually or by a formula.

See what you think.

TonyB