Format duplicate cells if another cell is true

  • Thread starter Thread starter moormanjm
  • Start date Start date
M

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
 
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
Click to expand...

Send file to dguillett1 @gmail.com with a complete explanation and examples..
 
Back
Top