Good afternoon! Below is a sample of a very large Excel file. The columns across are record number, material type code, title, and series name.
Here's what I need: If the title matches, look in the series name column and highlight the ones that are different. See how the first two lines are missing the |v? I want those highlighted. I'm thinking conditional formatting of some sort? b1481815a 5 Kindred in death |aEve Dallas mysteries ; 29 b1461286a 7 Kindred in death |aEve Dallas mysteries ; 29 b1459533a 8 Kindred in death |aEve Dallas mysteries ;|v29 b1455210a b Kindred in death |aEve Dallas mysteries ;|v29 b1459552a c Kindred in death |aEve Dallas mysteries ;|v29 b1459696a l Kindred in death |aEve Dallas mysteries ;|v29 Here's an example of a larger selection...notice how the sheet is sorted by title, then by series name... b1474087a b Kind of blue |aAsh Levine mysteries ;|v1 b1527205a b Kind of cruel |aSimon Waterhouse and Charlie Zailer series ;|v7 b1533378a l Kind of cruel |aSimon Waterhouse and Charlie Zailer series ;|v7 b1546992a j Kindergarten phonics & ABCs |aStar Wars workbooks b1534826a b Kindle Fire HD : the missing manual |aMissing manual b1534826a b Kindle Fire HD : the missing manual |aMissing manual b1518533a b Kindle Fire HD for dummies |a--For dummies b1540426a b Kindle Fire HDX for dummies |aFor dummies b1499791a b Kindle Fire quicksteps |aQuickSteps b1540427a b Kindle Paperwhite for dummies |aFor dummies b1518532a b Kindle Paperwhite for dummies |a--For dummies b1506476a 5 Kindness goes unpunished |aA Walt Longmire mystery b1506476a 5 Kindness goes unpunished |aJohnson, Craig,|d1961-|tWalt Longmire mystery b1399093a b Kindness goes unpunished |aWalt Longmire mysteries ;|v3 b1481815a 5 Kindred in death |aEve Dallas mysteries ; 29 b1461286a 7 Kindred in death |aEve Dallas mysteries ; 29 b1459533a 8 Kindred in death |aEve Dallas mysteries ;|v29 b1455210a b Kindred in death |aEve Dallas mysteries ;|v29 b1459552a c Kindred in death |aEve Dallas mysteries ;|v29 b1459696a l Kindred in death |aEve Dallas mysteries ;|v29 Any ideas of how I can do this? Thanks! Eddie Eddie Clem, MLS Cataloging Librarian Outreach and Collection Services Kokomo-Howard County Public Library 305 East Mulberry Street Kokomo, IN 46901 765.626.0853|765.450.6290 (fax) ec...@khcpl.org<mailto:ec...@khcpl.org> | www.KHCPL.org<http://www.khcpl.org/> WorldCat Discovery now includes selected Howard County Memory Project Collections! [http://www.oclc.org/content/dam/oclc/worldcat-discovery/discovery-templates/215320-EG-blue-1.jpg]<khcpl.on.worldcat.org>