I posted a question a few days ago received three reponses that sounded all good and all but I could not figure out the solution.

Problem: I would like to find a formula (conditional I think) or a THIRD party software that works with Excel to fix my need.

NEED: I would like to have each row HIGHLIGHTED as I moved up or down in the worksheet so example if I was in CELL J21 the entire row of 21 would be highlighted. As I moved up or down in ROWS the HIGHLIGHTED area would follow the acitive cell/row.

Problem: In my responses from other users they said it was a "PRIVATE-SUB-WORKSHEET" function and gave me some sample formulas to try. I do not know what a PRIVATE SUB WORKSHEET IS. The second thing was I was un-clear where their FORMULAS began and ended. The third thing I was un-sure of is where do I put this formula?

Please Help!

As a new user to MR.EXCEL

I have been reading a lot of problems to see if I could help any too.

I am too new of a user to help anyone yet but I am sure learning.

Thank you

Keith Fowee

Foweek@aol.com

859.581.7232

859.466.6211