Excel 2007 highlight 2 cells/rows if condition on one cell. Want to highlight 2 cells in a 2 line report imported into excel if the cell on one line contains the word “product”, want to highlight that cell and the cell on the row above it. What kind of formula can I do this with?
