ok this is like one hell of a situation..

i want a code such that when an entire row is selected and colored
green, after it is colored, a particular cell in that row gets the
value "1"

what i mean is for eg, if i select row 9 and color it green, then "1"
should automatically be entered in Cell "J9". And when i select Row20
and color it green, J20 becomes "1"
Waht i basically need is for the cell in column "J" of the selected row
to change its value to "1"........ Can this be done! I basically use
this at work to both track the day's job as well as to sort.. and
everytime i color a row i need to manually enter the "1"........

somebody help!!!!!!!!!!!!!!!
anyone with the code pls email me if possible at
' ((mailto: )


--
jenny_gurl
------------------------------------------------------------------------
jenny_gurl's Profile: http://www.excelforum.com/member.php...o&userid=27504
View this thread: http://www.excelforum.com/showthread...hreadid=470179