Format duplicate cells if another cell is true

moormanjm · External Since: Jul 26, 2012 Posts: 1

Good afternoon all,

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!
-J

Don Guillett · External Since: Jul 16, 2011 Posts: 50

On Thursday, July 26, 2012 11:28:35 AM UTC-5, (unknown) wrote:
> Good afternoon all,
>
>
>
> 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!
>
> -J

Send file to dguillett1 with a complete explanation and examples..