Hi All,

Many people find conditional formatting a little complicated, specially when they have to do a little more then colouring cells or text/numbers in the cells. You can do much more than conditional formatting with a good understanding of Custom Formats in Excel. Excel see a cells format as having four Sections. These are, from left to right Positive numbers, Negative Numbers, Zero Values and Text values (“Positive Number “;” Negative Number “;” Zero “;” Text”).Each of these Sections are separated by a semi colon (;)... If you create a custom number format you do not have to specify all four sections. It is also very important to understand that the formatting of a cells value does not affect its underlying true value.

To show this we can type any number into cell A1, then go to Format>Cells-Number-Custom.

Regards,

Vibhor