How do I use conditional formatting in Excel 2010?

To use preset conditional formatting:

1. Select the cells you want to add formatting to.
2. In the Home tab, click the Conditional Formatting command. A drop-down menu will appear.
3. Select Data Bars, Color Scales, or Icon Sets. Then select the desired preset.
4. The conditional formatting will be applied to the selected cells.

How do I create a formula for conditional formatting in Excel?

You can create a formula-based conditional formatting rule in four easy steps:

1. Select the cells you want to format.
2. Create a conditional formatting rule, and select the Formula option.
3. Enter a formula that returns TRUE or FALSE.
4. Set formatting options and save the rule.

How do I print conditional formatting in Excel 2010?

Click File > Print > Print to print the list of conditional formatting rules.

How do I apply conditional formatting icons in Excel 2010?

Format cells by using icon sets

1. Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to.
2. On the Home tab, click Conditional Formatting.
3. Point to Icon Sets, and then click the icon set that you want. Tip: Icon sets can be combined with other conditional formats.

How to use conditional formatting in Excel 2010?

Open an existing Excel 2010 workbook. If you want, you can use this example. Apply conditional formatting to a range of cells with numerical values. If you are using the example, apply formatting to all of the sales data. Apply a second conditional formatting rule to the same set of cells.

How do you format a cell in Excel?

Assuming the existing rule is ‘Use a formula to dtermine which cells to format’: Edit the existing rule, so that the ‘Formula’ refers to relative rows and columns (i.e. remove $s), and then in the ‘Applies to’ box, click the icon to make the sheet current and select the cells you want the formatting to apply to…

When to use dummy formulas in conditional formatting?

Dummy formulas are a way to test your conditional formatting formulas directly on the worksheet, so you can see what they’re actually doing. This can be a big time-saver when you’re struggling to get cell references working correctly. In a nutshell, you enter the same formula across a range of cells that matches the shape of your data.

Can you reference other workbooks in conditional formatting?

You can’t reference other workbooks in a conditional formatting formula. You can sometimes work around #2 and #3. You may be able to move the logic of the formula into a cell in the worksheet, then refer to that cell in the formula instead. If you are trying to use an array constant, try created a named range instead.