I think you are along the right lines count(b2:aj2)=3

This will apply in cell aj2 and look at this cell and the preceding 34
cells.
but for the cells up to this cell it needs to be count ($b2:b2)3 then
copied accross

You also wish to look at the cell and the following 34 cells as well
so you need
count(b2:aj2)=3 in cell b2 as the other condition. It can then also be
copied accross

In both instances format the conditional formating to turn the cells
red and it should work

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=555488