How to create conditional formatting in Google Sheets The easiest way to set conditional formatting on Google Sheets is by using the Format option in the Google Sheets toolbar.

To use the Format Painter, select the cell or cells whose formatting you want to copy, and click "Format Painter" in the Clipboard group of the Home tab on the ribbon.