Text in a Number Field
I have a Field named Hammer Price which is a Number Field. If the field is >1 than I would like it to read the number. If the field is 0 than I would like it to show "Bought In" in the field. Is that possible? Also is it possible if there is a loss for the # to be red and in parentheses?