You can set up a variety of rules for Sheets to obey, including determining whether a cell is empty or not, if it contains a date that is before or after a specific point in time or if it contains text that starts or ends with a particular phrase. Here are our step-by-step instructions for how to use conditional formatting in Google Sheets. MORE: How to Wrap Text in Google Sheets

  1. Select cells you want to apply conditional formatting to. 2. Click Format. 3. Select Conditional formatting. 4. Click Cell is not empty.
  2. Enter the value your condition refers to.  If you chose Cell is empty or Cell is not empty, will skip this step.
  3. Click Default and select a formatting style to apply to the cells.
  4. Click Done. Your Google Sheets spreadsheet now follows conditional formatting rules.

Google Sheets Tips

Previous TipNext Tip

Use Google Sheets OfflineOpen Google Sheets in ExcelCreate Filters in Google SheetsHere’s Every Google Sheets Keyboard ShortcutWrap Text in Google SheetsConvert Excel Spreadsheets to Google SheetsMake a Chart or Graph in Google Sheets