Google Sheets IF Dropdown Is Selected: Formulas and Tips

To make Google Sheets respond when a dropdown is selected, test the dropdown cell with an IF formula—for example, if the dropdown is in A2, enter =IF(A2="Approved","Continue","Choose an option") in another cell. Use a different response in the formula to match what you want to happen; a formula displays a result but does not itself change the dropdown or perform an action.

What “if a dropdown is selected” can mean

People often mean one of several things by asking whether Sheets can do something “if a dropdown is selected.” They might want a message to appear, show or calculate a related value, highlight the selected row, or start an automated task. The right method depends on the outcome:

Use an IF formula to show a value or message based on the choice.
Use conditional formatting to change a cell’s appearance.
Use data validation and a range of options to create or manage dropdown choices.
Use Google Apps Script when a user edit needs to trigger an action beyond displaying a formula result.

A dropdown is a cell with a data validation rule that offers choices. Once someone chooses an option, the cell contains that value. A formula or formatting rule can check that value, just as it can check ordinary text typed into a cell.

Create or check the dropdown

In Google Sheets in a web browser, select the cell or range where the dropdown should go. Choose Insert > Dropdown, or choose Data > Data validation to create or edit a validation rule. Add the options, such as “Approved,” “Needs review,” and “Rejected,” then save the rule. If a dropdown already exists, selecting its cell lets you inspect or change the rule.

For a short, fixed list, enter the options directly in the rule. If the choices are maintained in a separate range, use a dropdown sourced from that range so changes to the source list can be reflected in the dropdown. The exact controls shown depend on the kind of rule you choose, but the key point is that selecting an option puts that option’s text in the cell. Formulas should refer to the cell that actually contains the choice, not to the validation settings.

Decide what should happen when the cell is empty. A user may not have chosen anything yet, or may clear a previous choice. Handling that empty state explicitly usually makes a sheet easier to read.

Use IF for a specific dropdown choice

Suppose A2 contains a dropdown with “Approved,” “Needs review,” and “Rejected.” To show a different result for one particular choice, put a formula in another cell, such as B2. With the dropdown in A2, enter this formula in B2:

=IF(A2="Approved","Ready to process","Not approved yet")

If A2 is “Approved,” B2 displays “Ready to process.” If A2 contains either of the other options, B2 displays “Not approved yet.” The formula does not modify A2. It evaluates again when the dropdown value changes, so the result updates without the user having to re-enter the formula.

The text inside the quotes must match the dropdown option. For example, “Needs review” is not the same text as “Needs Review” if capitalization differs, and extra spaces can also cause an exact comparison to fail. You can nest IF functions for several outcomes, but a long chain becomes difficult to maintain. For a small list, make each branch clear; for a larger workflow, consider a lookup table that maps each option to a corresponding result.

Respond whenever any option is selected

If the specific choice does not matter and you only need to detect whether the cell has a value, test whether it is not empty. With the dropdown in A2, put this in B2:

=IF(A2<>"","A choice has been made","Choose an option")

This checks for a nonempty value. It is useful for status prompts, completion indicators, and simple forms. If you want B2 to display the selected option itself after a prompt, use:

=IF(A2<>"","Selected: "&A2,"No selection yet")

For example, if A2 contains “Needs review,” B2 displays “Selected: Needs review.” The ampersand joins text together. These formulas are examples for one row; if the sheet has many records, copy the formula down so each row checks its own dropdown cell.

Return a related value instead of a message

A dropdown can control a calculation or a value pulled from elsewhere. For example, a project tracker might use a status dropdown to show a target completion time or a category label. Keep the option-to-result mapping in a small table when there are several choices, so you can update the mapping without rewriting a complicated formula.

For a simple two-outcome case, use an IF formula. If A2 contains the dropdown and B2 should show a number only for “Approved,” enter this in B2:

=IF(A2="Approved",100,0)

The result is 100 for “Approved” and 0 for every other value, including a blank cell. That may not be appropriate for every workflow: a blank selection is often different from a rejected or unapproved item. Add a separate blank check when those states need different results. Also make sure the output cell is not part of the dropdown cell itself; a formula and a user-selected value should occupy separate cells.

Highlight a choice with conditional formatting

If the goal is visual rather than textual—for example, make “Rejected” stand out—use conditional formatting. Select the cells to format, then choose Format > Conditional formatting. In the conditional-formatting panel, create a rule that applies when the cell text is exactly “Rejected,” and choose a fill color or text style. Set the range to include the dropdown cells or the whole row, depending on what should be highlighted.

To apply a rule based on a different cell, use the panel’s custom formula option and write a condition that refers to the dropdown column. For instance, if dropdowns are in column A and the rule is applied to rows 2 through 100, a custom formula can check the first row’s A cell and use an absolute column reference so the rule follows each row. Check the “Apply to range” setting carefully: a correct condition can still appear not to work if the formatting rule is attached to the wrong cells.

Conditional formatting changes appearance, not the stored dropdown value. It is often the cleanest option for a color-coded status board because it avoids adding extra formula output columns.

Handle blanks and common problems

A formula that tests a dropdown can seem broken for a few straightforward reasons. Check these points before rebuilding the sheet:

Wrong cell reference: Confirm the formula points to the cell where the user makes the selection, not the cell where the formula result appears.
Text does not match: Compare the formula’s quoted text with the actual dropdown option, including spaces and punctuation.
Blank has no separate treatment: A formula that checks only for “Approved” may show its alternative message for a blank cell. Add a blank case if blank should produce its own prompt.
Formula is in the dropdown cell: A formula cannot also preserve a user’s manual selection in the same cell. Keep the choice and the calculated response in separate cells.
Formatting range is wrong: In conditional formatting, confirm that the selected rule covers the cells you expect and that its references line up with the first row of that range.
Unexpected option is allowed: Review the data-validation rule if users can enter values other than the listed choices. Depending on the rule settings, Sheets can reject invalid entries or show a warning.

To make a formula distinguish blank, approved, and other values, put a blank test first. With the dropdown in A2, enter this in B2:

=IF(A2="","Choose an option",IF(A2="Approved","Ready","Not approved"))

When A2 is empty, the result is “Choose an option”; when it is “Approved,” the result is “Ready”; any other nonblank value returns “Not approved.” The order matters because the formula checks the blank case before testing for approval.

Formula response versus automatic action

An IF formula is suitable when the desired response is a value in the spreadsheet. It can show instructions, calculate a quantity, or return a status, but it does not send an email, move a file, or create a notification by itself. This distinction is a common source of confusion: a cell changing its displayed result is not the same as a workflow action running.

For actions that occur after a user edits a cell, Google Apps Script provides edit triggers, including the simple onEdit(e) trigger. A script can inspect the edited range and its new value, then carry out supported actions. That requires writing and authorizing code where applicable, and the script needs safeguards: it should respond only to the intended sheet and dropdown range, and should handle unexpected or cleared values. Script behavior also differs from a formula’s automatic recalculation. For a basic status message or highlight, a formula or conditional-formatting rule is simpler and easier for other editors to understand.

Frequently Asked Questions

Can Google Sheets display a message when I select a dropdown option?
Yes. Put an IF formula in a separate cell that checks the dropdown cell and returns the message for the selected option. The formula’s result updates when the selection changes.

How do I check whether a dropdown is blank?
Use an IF formula that compares the dropdown cell with an empty string, such as =IF(A2="","Blank","Has a value"), assuming the dropdown is in A2. This treats a cleared dropdown as blank.

Can a dropdown selection automatically change another cell?
A formula in the other cell can display a value based on the selection, but it does not write a new manual value into that cell. For an action that edits cells or does more than calculate a result, consider Apps Script.

Can I color a row based on a dropdown?
Yes. Use Format > Conditional formatting, apply the rule to the rows you want to highlight, and base the condition on the dropdown value. Check the rule’s range and references if the color appears on the wrong row.

Why does my IF formula not recognize the selected option?
Most often, the formula references the wrong cell or the quoted text differs from the dropdown option. Check spelling, spaces, punctuation, and whether the cell is blank. Also keep the formula in a separate output cell rather than the dropdown cell.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.