Prevent Morethan another cell value

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.