That was my point. His reply seemed to say he merely put the formula in a cell. But, conditional formatting is needed to change cell colors. Also, the formula doesn't make sense. I opened Excel and copied the formula to a cell. The value in H26 can be anything; it has no effect on the other cells.