ExcelBanter - Applying a cell format within a Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Applying a cell format within a Formula (https://www.excelbanter.com/excel-discussion-misc-queries/155124-applying-cell-format-within-formula.html)

BRMeter

Applying a cell format within a Formula

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

Pete_UK

Applying a cell format within a Formula

A formula cannot change the format of a cell - it can only return a
result. Perhaps conditional formatting is something you should be
looking at?

Pete

On Aug 21, 2:42 pm, BRMeter wrote:
Does anyone know how to apply a format within a formula? such that the
result can determine the cell format?

Duke Carey

Applying a cell format within a Formula

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?

All times are GMT +1. The time now is 03:35 PM.