Row highlight

[alliswell]

Hi every body
Whenever i select any cell it must highlight that row with fill color grey & text white. Sheet name is COUNT

Thanks n regards

 

[Peter_SSs]

Try just tweaking the formatting in this suggestion.

 

[alliswell]

Thanks peter.

Peter but when i copy the highlighted row
To other sheet the highlight color also get copied

 

[Peter_SSs]

There was no mention of wanting to do that in your original question.

It is normal that when you copy/paste something that everything about it gets copied.
So perhaps you could detail more about just what you have, what you are trying to do, whether you are wanting to do it manually or by code etc.

 

[alliswell]

There was no mention of wanting to do that in your original question.

It is normal that when you copy/paste something that everything about it gets copied.
So perhaps you could detail more about just what you have, what you are trying to do, whether you are wanting to do it manually or by code etc.

I didnt knew about it much, so i didnt mention, i thought it is just virtual selection. Just need to copy selected rows to other sheet but the the highlight color shud not get pasted.

 

[Peter_SSs]

I'm not sure that I would call that giving "detail" of the points I mentioned so all I can offer is: Just use Paste Special (Values) in the other sheet