Thread: If filter condition donot match

I am trying to filter a depending on the textcolor in a column (done this in the VBA) and it is working fine. but i am repeating the same process on a few spreadsheets and in some cases there might not be any rows to display according to the filtered condition, if this is the case i want to display a string that i choose. How to do that? i have attached the file tks.

Pl see the attached file. I have used helper cells from A400.
If solved mark the thread solved.