Conditional formatting

Occasional Visitor

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?

1 Reply


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.