Strange Excel Spinner Buttons Help??

[stangirl87]

Ok. I need a way to make buttons do the following.

Based on whether or not (Skill Name) is formatted (blah blah vlookup true) the (Ranks) increases by 1 for each click up to a maximum equal to Cell(blah)+3
If (Skill Name) is /not/ formatted, the (Ranks) needs to go up by .5 for each click. ....
I am soooo out of my expertise here. the table looks like this currently

Skill Name Total Ranks Modifier
(Con. Form) (=sum) (button Here) (equal to other cells)
Alchemy* 0 0 0
Animal Empathy* 3 0 3
Appraise* 0 0 0
Balance* 4 0 4
Bluff* -2 0 -2

Skill Name formatting:
=VLOOKUP(N13,Skills,MATCH(B3,Classskills,0),FALSE) ="C"

Whole sheet(s) available upon request if you need more information.
Thanks in advance for all your help.

[Excel Fox]

Welcome to ExcelFox community.

Yes, it would be nice if you could upload a sample file which represents your actual data set. Posting an expected output for a couple of scenarios will also help.

[stangirl87]

https://docs.google.com/open?id=0Bz9...UtablB1UWJJbjA

Looking at the 'skills' portion on the right hand side of sheet 1.
If the skill name is highlighted, then the button should go up one whole number per click. If the skill name isn't highlighted, then it should only go up by .5 per click.
the maximum number in each box should be equal to your level+3. Or half of that for cross-class(non highlighted) skills.
So lets say you are a ranger (what the sheet is set to) the first three skills are:

Alchemy(cross class) the spinner button should go up to no more than: 5.5 (or eleven(level 8+3)clicks at .5 per click)
Animal Empathy (class) button should go up to 11 (eleven clicks at 1 per click)
Appraise (cross class) button should go up to 5.5 (eleven clicks at .5 per click)