Use Conditional Formatting to apply formatting, such as colored shading, to cells in a column based on their values. For example, in the following worksheet, cells in C1 that contain values greater than 150 have red shading and text.
You can apply more than one rule to a column. For example, for a column of test scores, you can apply one rule that formats cells that contain passing scores as green. You can then apply an additional rule to the same column that formats cells that contain failing scores as red. Conditional formatting rules are reapplied when the worksheet view refreshes.
You can subset a worksheet by rows that contain cell formatting. Click in the worksheet, then right-click and choose , or .
If you want to apply formatting to adjacent cells manually, regardless of the values, select the cells, then right-click and choose.