Hi
Try the following code, which I found some time ago, sorry I cannot remember from whom, place the code in the relevant sheet module
to change the highlighting colour simply change the interior color index value. If you want only the row then just delete the column references.
If you need to turn off the highlighting then you can add the following in a standard module
Use any available blank cell instead of the above and add a keyboard shortut, remove commenting from the two lines in the above.
regards
Jeff
Bookmarks