Drop down list question

[sparkytech]

I have 2 drop down lists in A1 and B1, both with a “Yes” or “No” selection. How can I make A1 change to “Yes” automatically if B1 is set to “Yes”? I can’t use macros, only formulas, etc.

 

[ranman256]

enter VBE (alt-F11)
in the Projects viewer, (leftmost pane)
dbl-click ThisWorkBook
then paste the code below into the rightmost pane. (the code pane)

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Value = "Yes" And Target.Address = "$B$1" Then Range("A1") = "Yes"
End Sub

if you want to use a formula, then combo1 must put its value somewhere else,THEN A1 formula = If(B1="Yes","yes",Z1)

 

[sparkytech]

Thanks for the reply. Unfortunately, I can’t use VBA, due to using this sheet on mobile devices. Maybe I’m not understanding, or I didn’t explain it very well . How do I have a “Yes/No” data validation list in A1 and B1, and if B1 is set to “Yes”, then automatically put “Yes” in A1? What I am trying to accomplish, is 45 day (cell A1) and 10 day (cell B1) reminders in my sheet. When the finish date is closer than 45 days, A1 turns red. When the finish date is closer than 10 days, B1 turns red. Selecting “Yes” in either cell turns it green. If the 10 day reminder is set to Yes, then that means the person has already completed the 45 day task, so it can be set automatically to “Yes”. I hope that makes better sense. Thanks!