Hi


I can not understand why the result of below mentioned formula makes
the cell BLUE.
=IF(AND(O$3=$K8,O$3<=$L8),1,"")

and with another formula as below it makes the cell RED or GREEN or
Brown.

=IF(AND(O$3=$K12,O$3<=$L12),IF($G12="Completed",3 ,IF($G12="In
Progress",2,1)),"")

May somebody explain why are so?

THK

hme


--
hme
------------------------------------------------------------------------
hme's Profile: http://www.excelforum.com/member.php...o&userid=15930
View this thread: http://www.excelforum.com/showthread...hreadid=537999