Conditional Formatting Based On Another Cell Google Sheets

Those formatting options visually enhance spreadsheets. Google Sheets also includes a handy conditional formatting tool that enables users to apply selected formatting styles to cells that match a specified condition. With that tool, you can apply conditional formatting to a selected cell range that’s based on another cell’s value.

How can I use conditional formatting based on another cell in Google Sheets?

1. Apply conditional formatting based on a single cell value

Now cells B2, B4, and B5 within the B2:B6 range will have orange cells and bold text as shown in the screenshot directly below. Those cells have the selected formatting applied to them as they include higher numbers than the value in C2 the condition is based on.

Note that cell references must always be entered as a formula with = preceding the reference. They must also always include a $ sign between the column letters and row numbers. You can apply conditional formatting to cells that include dates. For example, you could select the Date is before option to apply formatting to a cell range that includes dates based on a date in a referenced cell. The Format cells if menu also includes several text options. The Text is exactly option would apply formatting to cells with text that exactly matches that of a referenced one.

2. Apply conditional formatting based on multiple cell values across columns

What you’ve done in the example above is to apply red cell formatting to cells A2 and A4 based on all the cell values in their rows (across columns B to D). As the rows for January and March include cells with values less than 200, red formatting is applied to the Jan and March row headings.

The above examples show you how to apply relatively basic conditional formatting to spreadsheets in Google Sheets. You can enhance your spreadsheets’ presentation in many ways by applying conditional formatting with custom formulas and the other options on the Format cells if drop-down menu.

Name * Email * Commenting as . Not you? Save information for future comments
Comment

Δ