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?.

As for sheets ,I want font colour only to be changed not interior.

Waiting for your kind reply