Hi Richard,

=IF(1, "HighlightRed", "") will put "HighlightRed" in the cell regardless of anytghing else, since "1" is always TRUE. If you want to check whether a group of cells are equal to zero, then test =IF((A1+B1+c1+d1)=0,"HighlightRed","") - add the cells up and see if the result is still zero.

I think that we're missing something simple here. If you ZIP up your data and send it to me in an e-mail with the name of the statement that's giving you a problem, then I can take a look and see what it might be. Once a row gets the attribute "FormatHidden", it can be hard to remove and may cause unexpected results. Zero suppress is normally the best way to proceed.

Also, was this statement started by dragging and dropping account ranges from the group tree, conversion of a DOS specification, editing a sample specification or just starting from scratch and typing formulas.