I am wondering if Excel has the capability of detecting a series of numbers.
For example, I am tracking attendance in a given row with "1" being present
and "0" being absent. When someone is absent for three days straight (0 0 0
in a given row), can Excel give me a warning of some kind? I know that with
Filters, Excel can give various warnings or prompts.

Any help you can provide would be appreciated!