The formulas themselves don't have any effect on the colors. There must be
conditional formatting in the cells you mention. Check under the Format...
Conditional Formatting... menu.
--
- K Dales


"hme" wrote:


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