The essence of the formula follows this statement:įormat cell if custom formula is … They run in a similar way to an if function in Sheets.
In the text box below, we will enter our custom formula.įrom this point, the Google Sheets docs on Conditional Formatting are not entirely awesome at demonstrating how to use Custom formulas.Īll custom formulas start with an equal sign (=).Under the Format rules, select the dropdown and scroll to the bottom to select Custom formula is….The Conditional Formatting sidebar will appear.Navigate the dropdown menu to near the bottom and click Conditional formatting….Select the range that you want formatted.To access the Custom Formulas in Google Sheets Conditional Formatting: Getting to Custom Formulas in Conditional Formatting Throughout the examples, we’ll look at various aspects of using Custom Formula to match, use formula functions and apply multiple conditions.īefore we hit the examples, let’s briefly go over accessing the Custom Formula in Google Sheet’s Conditional Formatting. Example 6: Conditional Formatting a Single Column Based on Two Values.Example 5: Conditional Format a single column range based on a value in another column – Multiple times.
If both are present, the formula will calculate the average sales per order by dividing the total sales by the total orders.If the total number of orders is missing, the formula will display “Missing Total Orders”.If the total sales is missing, the formula will display “Missing Total Sales”.To do so, we set the following conditions: We wish to have the formula indicate what is the missing quantity for each entry. The total sales and total orders completed per team.