select a column > set condition
Format Painter quickly copies and applies cell formatting to other cells or ranges in your spreadsheet.