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