Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Data Validation > Restrict to Percentages - Range< Previous | Next > 

 

Step 1 - Highlight the cells

 




 

Step 2 - Enter the Criteria

 

 

Select Decimal

 
 

Minimum of 0.05 or 5%

 
 

Maximum of 0.3 or 30%

 

 

You can enter either the value 0.05 or 5%

 
 

SS

 



 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >