Conditional formatting depending on drop down other cell?

[Frigide]

Let say A1 is a drop down menu. It has 2 choices. "Start" and Stop""
B1 has also a drop down menu. Olso 2 choices: "Yes" and "No"

I want B1 turn red if A1 says stop until B1 says yes. As long if there is no choice there is no color.

[protonLeah]

=AND($A$1="stop",$B$1<>"yes",$B$1<>"")

[Frigide]

No correct formula

[AliGW]

Before we help further, please update your thread title to properly explain what you are trying to do. Generic titles are of no help.

Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

[AliGW]

Thanks for changing the thread title.

Try changing the commas in the formula suggested to semi-colons:

=AND($A$1="stop";$B$1<>"yes";$B$1<>"")

[Frigide]

Thanks for changing the thread title.

Try changing the commas in the formula suggested to semi-colons:

=AND($A$1="stop";$B$1<>"yes";$B$1<>"")

I'm not sure where to put this? In a conditional formatting line?

[JeteMc]

I believe that a formula which will accomplish the goal is: =AND(A1="stop";B1="no")
To apply the formula select cell B1 then open conditional formatting,
Select New rule,
Select Use a formula...
Paste the formula into the window below Format values where...
Select a fill and/or font.
Let us know if you have any questions