Highlight the entire row for cell that I am working in.

[frankday]

I am building a wide spread sheet. I want to develope a Macro that will highlight the entire row of the cell that I am working in. This way I can quickly scan over and see that I am entering data into the right row. I would also like to make this highlight non printed.

[Bob Phillips]

Select all applicable rows and add a conditional format with a formula of

=CELL("row")=ROW()

and set a highlight colour.

Then add this worksheet event cide

Please Login or Register  to view this content.

[frankday]

Can I do the same thing with the column and row? How would I do that?

[jeffreybrown]

Might this help...Color Banding

[Bob Phillips]

Can I do the same thing with the column and row? How would I do that?

Change the CF formula to =OR(CELL("row")=ROW(),CELL("col")=COLUMN())