I am dealing with a lot of data and I ma trying to highlight the row of the
cell I am currently working on. Any suggestions that Excel 2007 can perform
with out add-ons?

EXCEL 2007

Using row 7 as an example.

Click on the number 7 to highlight the whole row.

Right click.

Format Cells . . .

Fill tab

Fill with a colour of your choice.

OK.

Work in the row and then remove the formatting once you have finished.

If my comments have helped please hit Yes.

Thanks.














"mock" wrote:

I am dealing with a lot of data and I ma trying to highlight the row of the
cell I am currently working on. Any suggestions that Excel 2007 can perform
with out add-ons?

Hi,

I prefer the Rowliner addin and you can Google for that if you want but
here's a way with an addin

Right click your sheet tab, view code and paste this in

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.FormatConditions.Delete
With Target.EntireRow
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
With .FormatConditions(1)
.Interior.ColorIndex = 20
End With
End With
End Sub
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"mock" wrote:

I am dealing with a lot of data and I ma trying to highlight the row of the
cell I am currently working on. Any suggestions that Excel 2007 can perform
with out add-ons?