You cant do it within the formula
Just do the formula as normal, then highlight the cell and go into conditional formatting as usual. Make the condition Equal To and then just type Out Of Balance in the field and set the required format
Audiojoe
This message was edited by Audiojoe on 2002-05-13 07:01