Please Help for VBA code if

[Jagat Pavasia]

hello, dear,

I have excel macro enabled worksheet and i uses filtered raw with start A5 to R5.
means 18 standing line in my excel.o.k.

I want that if i filter C5 than C5 will change either color or font style etc.
If i filter D5, than same thing do.

so that i can easily find that which raw are filtered, and which are not filtered.

please help me.

 

[Jagat Pavasia]

this is image of my work sheet

https://ibb.co/1GDGQhZ



and this is my manual color changed raw in E5 and M5, see link below

https://ibb.co/kMqdgwz