EXCEL TRAINING MANUAL 2.2 COLUMN NOT WIDE ENOUGH  2.3 DIVIDING BY ZERO  3. CONDITIONAL FORMATTING Page 8 GLYPH<g3> If the rules (conditions) that you specified are met, then the formatting is applied.  With conditional formatting, you can select one or more cells, and create rules (conditions) for  when and how those cells are formatted. The conditions can be, based on the selected cell's  contents, or based on the contents of another cell.  You can control the following formats:  This problem can be overcome by using the  Excel IF function  to identify a possible division  by 0 and, in this case.  A #DIV/0! error message occurs when a formula tries to divide by zero. This article covers  situations when this error will occur and how to correct it.  Sometimes referred to as “Railroad tracks”, this condition is not really an error, but it  occurs frequently and it can be frustrating if you don't know what it is or how to fix it.  Number format  Font, font style, and font colour (but not font size)  Fill colour and fill pattern  Border colour and border style (but not border thickness) 