Originally Posted by djemy1975 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" Originally Posted by djemy1975 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.
Forum Rules