The third expression is for all numerical values that don’t meet either the first or the second condition. In the above example, the second expression # tells the application that when a number (the # sign) entered in the cell is greater than 500 (the part of the expression) then show the cell content in Blue color (the part of the expression). Like expression 1, the second expression specifies the format to use when the condition specified in the second expression is met alongwith the format to use. In the above example, the first expression # tells the application that when a number (the # sign) entered in the cell is greater than 750 (the part of the expression) then show the cell content in Red color (the part of the expression). The format to use in such a case is also specified alongwith. The four expressions are interpreted by Excel in the following order:Įxpression 1 This specifies the format to use when the condition specified within the expression is met. If two are specified, they are taken as expression 1 and 2 and so on and so forth. If only one expression is specified, it is assumed to be the expression 1. Please remember that all the expressions are optional and you can specify any number of custom formats ranging from one to four. In essence: Expression = condition_when_to_use_format + format_to_use_when_true Each of the expression is a combination of a conditional statement (which when evaluating to true triggers the format) followed by the actual format to use when the condition evaluates to true. You can specify either one or more expressions (upto a maximum of 4) as a custom format for a cell.
The custom format option allows for upto 4 expressions to be specified for a given cell value. So, now with the basics out the way, let’s delve a bit deeper into the world of custom formatting.
Apply a set of formats to a cell and check how it appears. If you are just beginning to learn this feature, take a minute to familiarize yourself with it. The custom format feature is the last one in the list of categories and provides a set in pre-defined commonly used custom formats including those for date, time and text. The following option box appears on the screen. To apply custom format in Excel 2003 and earlier versionsĬlick on the menu “Format” -> “Cells…” or use the Excel shortcut Ctrl+1 from the keyboard.
So as you can see, the custom format feature can help make cell values more descriptive and help the reader make better sense of the data. Similarly you can also change this cell to appear as “You scored 100” while the actual value remains 100. The actual value in the cell remains 100. Now if you wanted to change the appearance of this cell and convert this to $’s (without actually changing the actual value), you can use the custom format feature so that the number is shown as $ 100 and not 100. For example, suppose you have a figure, say 100, present in a particular cell of a column which stores the daily sales for a product. Using this feature will retain the underlying data but will change its appearance on the screen. The only change is of how the value appears to the user on the screen.Ī custom format can be applied to a particular cell or a group of cell. Before we get into the details, it is important to remember that when you format a cell using this feature, it does not change the value present in the cell. The custom format feature in Excel allows the user to “paint” or mask a number, text, date or time value in a user defined custom format.
0 kommentar(er)
