How do you use conditional formatting?

select a column > set condition

Format Painter🧹?

Format Painter quickly copies and applies cell formatting to other cells or ranges in your spreadsheet.