Is there a way with (excel 2000) where a cell meets a certain value (ie: 1 or 2) then the whole row turns a certain color...??? Conditional formatting seems to work only for that cell...