H
hme
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
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