Hi Friends,
i have a challenge i need to prevent the value is more than A1 cell value in B1.
Example: if A1 value is 10 then unable to enter morethan 10 in B1 cell.
Thanks
Liju M
Hi Friends,
i have a challenge i need to prevent the value is more than A1 cell value in B1.
Example: if A1 value is 10 then unable to enter morethan 10 in B1 cell.
Thanks
Liju M
Select B1
on the Data Tab, click Data Validation
Select Decimal (or Whole number if no decimals will be entered)
Select Less Than Or Equal To
Put =A1
Click OK
Hope that helps.
Thank you... Jomo1
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks