Select all the cells that need conditional formatting.

Select Conditional Formatting

Formula is: =$a1="open"


--
MABeatty
------------------------------------------------------------------------
MABeatty's Profile: http://www.excelforum.com/member.php...o&userid=32258
View this thread: http://www.excelforum.com/showthread...hreadid=555003