You can set up a conditional formatting rule beyond a particular range of cells. So, yes, you can highlight an entire row or column based on conditions. Select the row or column, then set up your rule as described above. Keep in mind that if you have empty cells, you may not see formatting based on value, text, or date.