A (not very elegant) possible solution:

Assumes the 12 values are in columns B to M.

In a spare column put this formula and copy down:

=IF(ISERROR(MATCH("below",$B2:$M2,0)),"",IF(AND(OF FSET($B2,0,MATCH("below",$B2:$M2,0))="below",OFFSE T($B2,0,MATCH("below",$B2:$M2,0)+1)="below"),1,0))

If three consecutive values of "below" are found, it puts 1 in the column or
if less than 3, then 0. If there are no "below" ratings it is left blank.

You could then set your conditional formatting based on the value 1 in this
column.

HTH

"welshobit" wrote:


Thanks both,:)

Ok both work in their own right great so thanking you kindly however,
lets say the example i gave earlier was based on an agents productivity
score based over a 12 week period and within that period they score a
below over 3 consecutive weeks say at weeks 5,6,7 how would it work
then?


--
welshobit
------------------------------------------------------------------------
welshobit's Profile: http://www.excelforum.com/member.php...o&userid=35589
View this thread: http://www.excelforum.com/showthread...hreadid=553538