Help with Possible Script

[milesy]

HI Guys

i want a script that is setup like the following...........i want to take starting position and do two things if the amount i have is less than the qty required make the row coloured and then subtract further qtys from the new starting position........

so for the below if my starting position for Part1 was 11 parts, line 1 would be green but line 3 would not

make sense??
i could post a sample worksheet but not sure how



PART ID QTY
Part1 10
Part2 15
Part1 2

 

[ranman256]

it looks to me Line 1 is NOT valid and would not be green.
line 2 looks correct and SHOULD be green.
unless green is NOT good.
can you clear this up?

 

[milesy]

it looks to me Line 1 is NOT valid and would not be green.
line 2 looks correct and SHOULD be green.
unless green is NOT good.
can you clear this up?

yes you are correct row 1 is of course the header row

 

[ranman256]

no , i was ignoring non data headers.
I was referring to the actual line 1 OF data.