Format duplicate cells if another cell is true

[moormanjm]

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]

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 willlook 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 @gmail.com with a complete explanation and examples..