Conditional formatting is giving me a bit of a headache this morning.
I have conditions that if the cells are less than another cell, flag red. If they are greater than, green. The cells with the formatting have a IF SUM formula in them to set the cells to null if the formula returns a zero. So before anything is put in, the cells all turn green which I don't want. I tried adding ISBLANK to my conditions and made it the first rule, but it did not prevent the cells from turning green.
Anyone have any suggestions?
I have conditions that if the cells are less than another cell, flag red. If they are greater than, green. The cells with the formatting have a IF SUM formula in them to set the cells to null if the formula returns a zero. So before anything is put in, the cells all turn green which I don't want. I tried adding ISBLANK to my conditions and made it the first rule, but it did not prevent the cells from turning green.
Anyone have any suggestions?