G Guest Aug 21, 2007 #1 Does anyone know how to apply a format within a formula? such that the result can determine the cell format?
Does anyone know how to apply a format within a formula? such that the result can determine the cell format?
P Pete_UK Aug 21, 2007 #2 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
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
G Guest Aug 21, 2007 #3 Perhaps you are thinking of Conditional Formatting, located on the Format menu
