Quote Originally Posted by djemy1975 View Post
Dear rlv,
Thank you for your prompt reply.It is working for all sheets ,but I want it to work on my listviw.Is it possible?.
I cannot say because I don't know what you mean by "my listviw"

Quote Originally Posted by djemy1975 View Post
As for sheets ,I want font colour only to be changed not interior.
In the code I posted, remove or comment-out the lines that set the background (interior) color.