I am trying to figure out if there is a way to apply multiple conditional formats in sequence in Excel. I have a series of numbers (bids) listed in columns. Each column corresponds to a specific company, each row (700 of them) is a manufacturing product with price bidding from each company. I have an extra column wich references the bids and choses the lowest bid (MIN value). I then wish to format the cells so that if the bid price matches the lowest bid then the cell will be filled green with dark green text. I can do a format of the first cell in the row, and drag it to the last cell in the row - applying the format to the entire row. Is there a way to format all of the rows in sequence without having to enter the conditional format to each row individually? Or will I have to do each of the 700 products/rows?