sueellen
12.08.12, 10:20
chce aby automatycznie naglowek zmienial kolor:
Green = space to meet production less than 85% full ,
Amber = Limited space at storage stores 85-94% full,
RED = space at 95% or above, production constraints
Wstawilam taka formule:
=IF(OR(C4<85%,C4>85%,),"GREEN","AMBER")
Brakuje mi jednak RED kiedy C4>94%
formula:
=IF(OR(C4<85%,C4>85%<94%,C4>95%),"GREEN","AMBER","RED")
nie dziala - wyswietla sie komunikat "you have entered too many arguments for this function"
Jak zrobic by wstawic wszystkie 3?