Google Sheets If Cell Contains

Then enter comma and specify the second argument.
Google sheets if cell contains. A string criterion must be enclosed in quotation marks. If the condition is true the function will carry out one operation. Each cell in range is then checked against criterion for equality or match if wildcards are used. As with excel s if function the if function in google sheets facilitates branched decision making within a worksheet.
I have two cells a1 and a2 where the attributes can be high risk medium risk or low risk. Formatting based on another range of cells values is a bit more involved. Go to the format tab. I d like cell b2 to return the highest risk rating from a1 and a2.
Select the cells that have the names a2 a11. From the format cells if drop down select custom formula is. Here are the steps to highlight cells with names based on the scores. Click on conditional formatting.
In the conditional formatting rules pane select single color. If range contains numbers to check against criterion may be either a string or a number. Google sheets if cells contains text then return text. If a number is provided each cell in range is checked for equality with criterion.
The second argument is a value that f2 will return if the condition is met. Using google sheets for conditional formatting based on a range s own values is simple. As with the other google sheets functions you don t need to enter the address of the cell manually mouse click is enough.