Hi all,
I'm struggling with one problem. I have a spreadsheet, where numbers are filled into columns A,B,C in values from 1 to 15. And I'd like excel to show msg box based on theese two conditions:
1. if 3 consecutive rows contain number lower than 5
2. if 3 consecutive rows contain number higher than 10
Show msg based on the value is no problem, but I don't know how to deal with the consecutive condition.
Thanks for any help!
Oxi.
I'm struggling with one problem. I have a spreadsheet, where numbers are filled into columns A,B,C in values from 1 to 15. And I'd like excel to show msg box based on theese two conditions:
1. if 3 consecutive rows contain number lower than 5
2. if 3 consecutive rows contain number higher than 10
Show msg based on the value is no problem, but I don't know how to deal with the consecutive condition.

Thanks for any help!
Oxi.