#If then formula conditional formatting how to

How to Conditional Format Based on Another Cell Recap Use the greater than operator to indicate which cell needs to have the larger figure eg: B2>C3.How Do You Conditional Format if One Cell Is Greater Than Another? Select the color you want to the formatting to apply.Enter a formula to set the rule for the formatting.How Do I Change Cell Color Based on Value in Another Cell? Yes, you can conditionally format a cell based on another cell. Google Sheets Conditional Formatting Formula Based On Another Cell FAQ Can You Conditionally Format a Cell Based on Another Cell? We could use the OR function to do this, like so: =OR(B2='F',B2='NB') Let’s say we wanted to also add the non-binary students. Change the Conditional dropdown box to Custom formula is.Navigate to Format > Conditional formatting.To highlight all the students that are female we can conditionally format the column with their names to green. We’ll use a small fake data sample to show how it would work. You could use conditional formatting to highlight all the female students. For a simple example, let’s say you work in a co-ed primary school and you need to suggest the top-performing female students for an all-girls private school scholarship program. You just have t enter the text string into quotation marks in the custom formula. You can apply conditional formatting in Google Sheets based on another cell that contains text too. Google Sheets Conditional Formatting if Another Cell Contains Text This would instantly highlight the names as shown below: Specify the format by clicking on the Formatting Style drop down.In the Formula field, enter the formula: =B280,C2>80,D2>80).From the ‘Format Cells if’ drop down, select ‘Custom Formula is’.In the Conditional Formatting rules pane, select Single Color.Select the cells that have the names (A2:A11).Here are the steps to us Google Spreadsheet conditional formatting based on another cell to highlight cells with names based on the scores: Suppose you have the data set as shown below:

Highlight Cells Using Conditional Formatting Based on Another Cell Value in Google Sheets You can highlight cells using conditional formatting based on another cell value in Google Sheets. You can use Conditional Formatting to highlight cells with a score of less than 35 in red and with more than 80 in green.īut what if you want to highlight a cell based on other cells value.įor example, highlight the name of students who got less than 35 in Math. You can use Conditional Formatting in Google Sheets to format a cell based on its value.įor example, suppose you have a data set of students’ scores on a test (as shown below).

If then formula conditional formatting