In the example above, let’s assume that you need to format the cells if its value is greater than 10. In this case, the range is set to 20 cells. For example, let’s say that you would like to format cells from B2 to B22, based on a condition. Range – Defines the scope of the rule.Every rule consists of the following three elements: Related: How to View and Remove Authorized Apps From Google Account Rules – What Does it Meanīefore thinking of using conditional formatting, first, you need to understand the structure of rules. Regarding rules, you can either use the existing ones available on Google Sheets or you can create your own rules as well.īased on your requirements, you can apply conditional formatting to a single cell, group of cells or to an entire row/column. You can change several aspects of a cell, like its background color, text type (Bold/Italic/Underline). It is a feature that allows you to modify/change the aspect of a cell, based on a single or set of rules. In this post, let’s take a look at some of the ways to use conditional formatting on Google Sheets. In addition to being the #1 user-friendly spreadsheet tool, Google Sheets also offer a cool feature called Conditional Formatting that helps users to quickly analyze complex or lengthy sheets. If it is Sunday (1) or Saturday (7), the condition will be true, so the conditional formatting will apply.These days, a lot of people prefer Google Sheets to Microsoft Excel for many reasons like zero cost, multi-user access, cloud storage, and most importantly you can access spreadsheets on the go from your smartphone. It will determine the day of the week that C13 represents. The formula will inspect cell C13 (and it will adjust as the range continues downward). Then under Formatting style, select the Fill Color button, and select the shade of grey you prefer. Then enter this in the custom formula box: In the Format rules section, pick Custom formula is. From what I can see in your screenshot, that would be D13:D20, and probably more. In the Apply to range box, enter the range you want the condition to apply to. Select the Conditional Formatting option. (If your Column C is just text, you can adjust the formula to look for the strings 'Saturday' or 'Sunday'.) So I'll demonstrate a formula that will work in that case. It looks like your dates in Column C are formatted as dates, and not just text. A custom formula in the Conditional Formatting interface can do this for you.

Google sheets if then formula color