red flag

[khalil]

hello


how to red flag when 9 consecutive entries are the same in column A, there are some blank cells in between.
we can use A1 as fixed cell to show red, and the entries will be in A2,A3....A100.

thanks

 

[khalil]

thank you my friend ,
after testing the code it worked perfect, disregard the last post reply,

this code worked great

 

[ZVI]

Glad I could help, Khalil.
Post back if you get any problems.
Regards,
Vlad

 

[khalil]

Thank you Vladimir, you are a good man

Khalil