Hi
one way:
- select C1:X1
- goto 'Format - conditional Format' and choose 'Formula is'
- enter the formula:
=COUNTIF(A1:C1,0)=3
- choose your format

"gracegift" wrote:

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!