Skip to content

Conditional Formatting in Google Sheets

Conditional formatting is a feature in spreadsheets that allows you to alter the appearance of a cell based on the value it contains.

For example, let’s say you have a simple to-do list with checkboxes.

Now for any task that is not complete, you want the checkbox to stay white with no color added. However, you want the checkbox to turn green for any completed task.

You can set up your spreadsheet to change the color automatically through the use of conditional formatting.

How to Apply Conditional Formatting

To apply conditional formatting in Google Sheets, follow the steps listed below.

Step 1 – Select the Cells

Start by selecting the cells where you want to apply the conditional formatting. For example, select the cells A1:A4.

Step 2 – Go to Format > Conditional Formatting

In the Google Sheets menus, go to Format > Conditional Formatting.

The Conditional format rules panel will appear on the right side of your spreadsheet. Click on Add another rule to get started.

Step 3 – Create Your Format Rule

Step 3 is where you specify the conditions that determine when to apply specific formatting to a cell.

For example, let’s say you want the formatting to be applied when the word “Complete” is entered into one of the cells in your selected range.

You would start by selecting Text is exactly and then type in the word “Complete.”

There are many different types of rules you can create. Let us know in the comments if there is a specific rule you want to learn more about.

Step 4 – Adjust the Formatting Style

The last step is to configure what you want the cells to look like when the word “Complete” is entered.

For example, what if you want the cells to contain a green fill color and want to strikethrough the text? Start by selecting green for the fill color and then click on the strikethrough option as well.

Finally, click on Done when you are finished.

Now anytime you type the word “Complete” into any cell within A1:A4, the cell will strikethrough the text and contain a green fill color.

And that’s how you can apply simple conditional formatting in Google Sheets.

This Post Has One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top