Until now in my excel charts I was able to color cells using formulas in the cells - now it doesn't work. Eg. I use "If" condition to show "1" when the result is right, there is no result. But if I write 1 directly, the Conditional formatting works. Any idea about it from somebody?