Sep 10 2019 05:49 PM
Hi, I am new here!
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?
Sep 10 2019 06:13 PM
Not sure what exactly you are trying to achieve here. Why not share a sample workbook to visualize the issue you are having?
Btw, in your IF formula, if you placed double quotes around 1 like "1", remove the double quotes and just type 1 in the IF formula and see if that works for you.