Mirokilili
New Member
- Joined
- May 15, 2018
- Messages
- 2
Hello,
I have a long list of books sorted by author. I need to highlight the authors with 10 or more books. I have a column that shows the count for each author using this formula:=IF(C3=C2,H2+1,1) where column c holds the authors names and column H counts each book for the author and starts over at 1 when a new author name appears.
SO I would like to highlight either the consecutive numbers from 1 to the last number for the author when the last number is greater than 9 or the entire rows for those authors.
I appreciate any help.
I have a long list of books sorted by author. I need to highlight the authors with 10 or more books. I have a column that shows the count for each author using this formula:=IF(C3=C2,H2+1,1) where column c holds the authors names and column H counts each book for the author and starts over at 1 when a new author name appears.
SO I would like to highlight either the consecutive numbers from 1 to the last number for the author when the last number is greater than 9 or the entire rows for those authors.
I appreciate any help.