Formatting a text or cell in Excel involves changing the size, type of font, color, bold, underline, and other characteristics of the text. In the case of conditional formatting, this means change the properties of the text in the event that certain conditions are met. To understand conditional formatting, imagine an electronic kitchen timer. When the time comes, to zero, it usually sounds an audible beep, a campaign, see any Flash or something similar. We can apply this same type of behavior to the formats of one or more cells. For example, if a cell contains one value less than 100, we can show this red color value. Similarly, if a cell has a value greater than 1,000, we can change the cell background color to green.
Apply conditional formats in Excel is very useful when we want to analyze a list of values and perceive that you values higher or lower to that certain quantities could be detrimental to our business. In Excel, you can easily change the following properties of the cells. The type of source. If the font is bold, italic, or both. The size of the font.
If the source has a single or double underline. If the font is strikethrough, superscript or subscript is. The color of the font. Change the thickness of the edges of the cell. Change the thickness of the edges of the cell. The color of the border. The color of the cell shading. To apply conditional formatting to one or more cells, select the cells that you want to format. Then on the Format menu, click conditional formatting. Enter the conditional formatting properties for condition 1. If you want to add more formatting options, click the Add button and enter another criterion. In versions earlier than Excel 2007, you can only create three simultaneous conditions. In the 2007 version, we can create unlimited criteria.