I have a cell in each row of my spreadsheet that has 6 possible values (7 if you include blank). I want the whole row to turn a different color based on the value in this cell, but conditional formatting will only allow me three different formats...I need at least 5, plus the default. Is there a way around this?