Microsoft Office Tutorials and References
In Depth Information
Formatting a cell based on conditions
Change the format of a cell based on the
results of a formula
1 Select the cells that you want to change.
2 Click the Home tab.
3 In the Styles group on the ribbon, click Conditional Formatting.
4 Click New Rule.
5 Click Use A Formula To Determine Which Cells To Format.
6 Type the formula that you want evaluated.
7 Click Format.
8 Specify the formatting that you want, and click OK.
9 Click OK.
TRY ThIS In a blank worksheet, click cell A1, click the Home
tab, click the Conditional Formatting button, and then click
New Rule. Define a condition that applies when a cell value is between
400 and 1,000. Specify that bold formatting be applied to the cells.
Click OK. Define a second condition that applies when a cell value is
less than 400. Specify that italic formatting be applied to the cells. Click
OK. Type 450 in cell A1, and press Enter. The cell’s contents are
displayed in bold type. Click cell A1, type 350, and press Enter. The
cell’s contents are now displayed in italics.