James,

In F6 the CF should be.

Formula is: =F5="Failed"

Click on format to apply the fill you want. Click OK, OK. It should
not matter that F5 contains a Data Validation list.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=510640