I have excel sheet where i am fetching stock market data, now it changes colour according to my conditional formatting rules, I want to know how many times in total colour has been changed in 1 particular data range during whole day
here below mentioned conditional formatting rule and range is
Any help is appriciated, Thank you
here below mentioned conditional formatting rule and range is
=$D$9:$I$52
Excel Formula:
=AND(D9<(D10*1.5),D9<(D8*1.5),D9<(D$7*0.7),D8<(D$7*0.7),D10<(D$7*0.7),D9<(D8*0.7),D9<(D10*0.7),D8>5,D10>5)
Any help is appriciated, Thank you