Forum Discussion

OwenO's avatar
OwenO
Copper Contributor
Apr 30, 2019
Solved

Some Excel help - Data validation using name ranges - force option if "False"

Hi I was looking for some help please. I have used a range    =IF($N$28="True",$Q$3:$Q$4,IF($N$28="False",$Q$4))   this works fine, in that the O3 & O4 cells are just Yes/No selections..    thi...
"True"
=IF($C$22>=590
  • OwenO's avatar
    OwenO
    Apr 30, 2019

    can mark this as resolved.. had to use a VBA script which is something i just learned today

     

    for anyone it may potentially help who googled and found this however I've added what I used above

     

    you go into VBA (Alt+F11), choose the worksheet you want

     

    click the "change" option on the right side

     

    and add the code below:

    If Target.Address = "$C$4" Then
    Range("E28").Value = "Please Select..."

    End If

     

    (change the cell values to match the ones you need..)

OwenO's avatar
OwenO
Copper Contributor
Apr 30, 2019

PeterBartholomew1 

 

thanks for the reply, the reason I done the true and false is because if its 590 or over I want the user to have the ability to select Yes or No, but if under 590 then the cell to automatically update to No

 

is this possible with the formula you referenced do you think?

 

 

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Apr 30, 2019

OwenO 

Many things are possible, that does not necessarily mean they are a good idea.  It is only too easy to get caught out by one's own 'cleverness' at a later date!  Using Booleans rather than strings probably is a good idea but the number formatting within conditional formats is a step too far.

Resources