Saturday, September 14, 2013

How to Use Conditional Formatting in Excel


1. Open a new or existing spreadsheet in Excel 2007. Enter any necessary data.
2. Select the cells that require conditional formatting. Select all cells if you don't need any cells to be exempt from the conditions.
3. On the Home tab of the Ribbon, click 'Conditional Formatting.' Choose 'Highlight Cells Rules,' then select the condition that matches your needs: For text, choose 'Text that contains...,' or for numbers, one of the other options. Let's assume you want to highlight cells containing numbers greater than 10: Choose 'Greater than...'
4. In the resulting dialog box, type '10' into the empty field, then to the right, click the drop-down arrow and choose either an existing format or 'Custom Format' to choose your own cell background and border, font color and more.

Blogger news