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:
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