Hi

I tried with this formula but it can't work.

=AND(COUNTIF($B4:$H4,"DO")=1) then conditional format to red for A4:I4.

Please help.

Thanks.

Nancy