Help!

I’m looking to create a conditional format on a cell which states an
agent’s name that will flag Red! Sounds easy yes! however I need it to
flag red only if they have three consecutive values in different
columns but in the same row i.e in cell a2 value =below, in cell b2
value=below and in cell c2 value = below. If the sequence went below,
above, below then don’t flag red.

Can this be done?


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