Help me Someone!!!!!

hmm okie i'l try it... if it works i'l give ya whatever u want!!!!!!!!!!

FYI - If you continiue to give your real email info in newsgroups you will get spammed bigtime. Spammers harvest email addresses
here. Most people do something like add the words NOSPAM to their email address and then add a note to remove the NOSPAM if emailing
to you. Everybody here is accustomed to that. You really wouldn't even have to add the note because that is such a standard
procedure.

HTH
--
RMC,CPA


"jenny_gurl" <[email protected]> wrote in message
news:[email protected]...

hmm okie i'l try it... if it works i'l give ya whatever u want!!!!!!!!!!


--
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

In the spirit of, "there is more than one way to do a job." Here's how I think I would approach this.

Instead of, "If row is green then col J=1" How about, "If J=1, then row is green" Here's how I'd set it up.

You'll manually enter 1 or 0 into column J like you are now. Select the rows of interest, then Format menu --> conditional formatting --> Formula Is --> $J7=1 (if active cell is in row 7) and set the color to green. Now, instead of going through the format cells dialog to turn the rows green then entering 1's in the green rows, you enter the 1's, and the rows automatically turn green.

Just another approach that could work for you.