Conditional formatting in Google Spreadsheets is hopeless to the point of not being worth trying. It needs to work on a cell by cell basis, not just column/row. And you need to be able to overload cells with more than one rule.