Hello,
I have a simple work book. Please refer to the attachment Book1.xls.
In B1, the data is limited (by Data Validation with a drop down List) to Yes and No.
I need to limit the range of data in D1 as, If B1 = Yes , then the value of D1 could be entered More or Equal to 51 ; and if B1 = No then the data entered into D1 should be Less than or Equals to 50
I prefer to do it with Data Validation. Please help.
Bookmarks