I am having nerve wrecking issues with Excel right now. I want to colour a cell, depending on the number in it, using a conditional format. I want three different Colour options.
So I wrote in the Minimum one: =IF($O$98<=1,5;1;0)
in the middle one: =IF(AND($O$98>1,5;$O$98<=2,5)=1;1;0)
and in the maximum one: =IF($O$98>2,5;1;0)
If I write These three Formulars outside if the conditional format, the work perfectly. However, having them in the format result in the cell alwys being red (the Colour for the highest Option), no matter what I type in.
Except when I write 0 in the cell, then it gets the Colour from the lowest one.
I have 2010 and have tried everything, changing the Formulars, not using the if Formular at all etc.
I cannot understand how at least this Version of Excel has a built in function for such cases but can only give the cell Symbols this way, not just colouring it.
Anyway, help would be greatly appreciated.
Bookmarks