Yes, you can use conditional formatting under the format option of the
toolbar. If you apply conditional formatting to say the first cell in the
column of choice, and assign your condition. Then you can copy that cell.
Highlight everything you want to apply that condition to in the column, and
paste special formatting. :) Task done.