=IF(K1="","no data",IF(K1<5,"green",IF(AND(K14,K1<9),"amber","r ed")))


this gives you no data if cell k1 is empty, and either red or amber or
green according to the value of k1................


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=555519