Menu

high lite a row

Search this Thread

#1

Report Post

Don Guillett

Posts: n/a

Default

glad it helped

--
Don Guillett
SalesAid Software

"Red" wrote in message
...
Thanks

"Don Guillett" wrote:

this should do what you want. Right click sheet tabview codecopy\paste
this. However, it will delete ALL other shading.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlColorIndexNone
Target.EntireRow.Interior.ColorIndex = 36
End Sub

--
Don Guillett
SalesAid Software

"Red" wrote in message
...
I am resending my previous question, I did not phrase it correctly.
Sorry.

I would like to be able to have the row I am entering information into
automatically be highlited. As I move up and down that row would
highlilte. I
am working with a lot of names in the column and a lot of data in the
rows
that I need to match up to the names.

Thanks again

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
High score list?	nc-nc	New Users to Excel	1	January 17th 05 10:33 AM

All times are GMT +1. The time now is 05:39 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement