Conditional formatting can be a great tool to enhance the data in your spreadsheet. There are several options for formatting a cell given the value of that particular cell. But what if you want to format multiple cells in a row based upon the value of one of more other cells? Well, that’s not so straightforward!
Let’s suppose that we have an Excel spreadsheet containing student data, but we want to be able to look down the list and quickly view all freshmen who are female chemistry majors: