The following works in Excel 2010:
1) Select Conditional Formatting
2) Select Manage Rules
3) Select New Rule
4) Choose the last option, "Use a formula to determine which cells to format"
5) In the "Format values where this formula is true" box, type:
=COUNTIF($C:$C,$C1)>COUNTIFS($C:$C,$C1,$D:$D,$D1)
[assuming that the C column is the title and the D column is the series]
6) Click on the Format button and choose your desired formatting options
7) Click OK
8) In "Applies to" box, type:
=$A:$D
[assuming that there are four columns--A-D]
9) Click Apply
This should apply conditional formatting to all of the rows where the titles
are the same but the series name varies (e.g., the "Kindle Paperwhite for
dummies", "Kindness goes unpunished", and "Kindred in death" rows in the
provided selection).
The formula is looking for cases in which the number of rows that have the same
title ("=COUNTIF($C:$C,$C1") is greater than the number of rows that have the
same title and series name ("COUNTIFS($C:$C,$C1,$D:$D,$D1)").
I hope that this does the trick.
--Vernica
