So, now with the basics out the way, let’s delve a bit deeper into the world of custom formatting.The custom format option allows for upto 4 expressions to be specified for a given cell value.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. Similarly you can also change this cell to appear as “You scored 100” while the actual value remains 100.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. Click on the menu “Format” - “Cells…” or use the Excel shortcut Ctrl 1 from the keyboard. 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.
Again like expression 3, you can’t specify a condition for expression 4.
The only change is of how the value appears to the user on the screen.
A custom format can be applied to a particular cell or a group of cell.
Please note that you will not be able to specify a condition for the third part – you can only specify the format to be used.
The condition will automatically be formulated up as anything that does not meet either condition 1 and condition 2 specified in expression 1 and expression 2.