Make Row outline them selfs

hard for me to describe what I want, but I will give it a shot

I am an accountant. Frequently I make a spread sheet, and need to do a "write up" as we call it.  I make columns with Descriptions. then we duplicate the amount in the " amount Column"  into one of the descriptive columns we made....
the result is that we are able to add up  all columns, and they agree in total to the amount column.

My problem is that as the work sheet gets large, I lose track of which row the number was originally in.  
is there a way that the whole row, could show itself or highlight... just by me clicking on any cell of it.?
intelogentAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

IrogSintaCommented:
Microsoft Dev Center explains how to highlight both row and column of an active cell in this link.  What the code does is clear all the colors in all the cells of the worksheet and then highlight a single row and column.  In your case of highlighting just the row, you would basically add vba code similar to this:
    If Target.Cells.Count > 1 Then Exit Sub
    Application.ScreenUpdating = False
        Cells.Interior.ColorIndex = 0
        Target.EntireRow.Interior.ColorIndex = 36
    Application.ScreenUpdating = True

Open in new window

While the above works, I prefer using Conditional Formatting to do this.  One benefit here is that it avoids flickering (though maybe this would not be an issue on faster CPUs).  Here are the steps to try this route:

1

Select Cell A1

2. Select All Cells

Do this by clicking on the upper left corner.Select all cells

3. Add Conditional Formatting

Select New Rule.
For the Rule Type, select "Use a formula to determine which cells to format"
Add the following formula : =CELL("row")=CELL("row",A1)
Select your formatting colorConditional Formatting

4. Add Code to Recalculate

Using the above steps, if you click on a cell and then press F9 to recalculate, you will see your row highlighted.  In order to make the recalculation automatic, you need to add the following code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Target.Calculate
End Sub

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
intelogentAuthor Commented:
so will the row now longer call attention to it self once a cell is no longer selected on it.?
0
IrogSintaCommented:
If you select a cell in another row, the new row will be highlighted.
0
intelogentAuthor Commented:
perefect and thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.