Google sheets conditional formatting if another cell contains text
Imagine you are a dutch diamond dealer quizlet
In this first example we want to apply a Conditional Formatting to the data set below. We want to format the row if every value in columns B, C, D and E is greater than or equal to 100. Select the range of cells you want to format (B2:E7 in this scenario). Click Home > Conditional Formatting > New Rule.