Perhaps you are thinking of Conditional Formatting, located on the Format menu

"BRMeter" wrote:

Does anyone know how to apply a format within a formula? such that the
result can determine the cell format?