How can appaly percentage validation in MSExcel 2010

Posted by Sekar.C under Others on 8/5/2013 | Points: 10 | Views : 717 | Status : [Member] | Replies : 1
Hi,
How can appaly percentage validation in MSExcel 2010
I have 2 columns GCType Drop down (Fixed,Percentage),GCValue(allow whole number) in excel Sheet

if(GCType='Percentage')
GCvalue(0 to 100)
else
GCvalue >0

Regards
Sekar.c



Responses

Posted by: Devasaso on: 8/5/2013 [Member] Starter | Points: 25

Up
0
Down
hi sekar,

pls go through below link:

http://www.mrexcel.com/forum/excel-questions/67333-cell-conditional-validation-percentage.html

Soubhagya

Sekar.C, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response