CODEWITHSUNDEEP
excel
Katheryn Overman
Katheryn Overman

Reputation: 21

How to highlight two rows based on cell values Excel 2013

I have 834,000+ rows of data in columns A-S. There are pairs of rows separated by a blank row. For each pair, I need to compare column S in both rows and if they both contain "Y", then I need both rows highlighted. If they don't match, then no action is taken. How can I set this up so that it skips the blank rows and highlights the pairs correctly?

Upvotes: 0

Views: 98

Answers (1)

Ditto
Ditto

Reputation: 3344

Try this formula in cell T10 : =AND(S10="Y",OR(S10=S9,S10=S11)) then copy it up and down. If that shows TRUE for the rows you want to highlight .. you can now easily setup a conditional format for the range, based on Column T. ;)

Upvotes: 1

Related Questions