Designing Conditional Formatting

You can make your worksheets more powerful by setting up conditional formatting. Conditional formatting lets the value of a cell determine its formatting. For example, you might want this year's sales total to be displayed in red and italics if it's less than last year's total, but in green and bold if it's more.

Establish a Conditional Format

graphics/one_icon.jpg

Select a cell or range you want to conditionally format.

graphics/two_icon.jpg

Click the Format menu, and then click Conditional Formatting.

graphics/three_icon.jpg

Select the operator and values you want for condition 1.

graphics/four_icon.jpg

Click the Format button, select the attributes you want applied, and then click OK.

graphics/five_icon.jpg

Click Add to include additional conditions, and then repeat steps 3 and 4.

graphics/six_icon.jpg

Click OK.

graphics/09inf08.jpg

Delete a Conditional Format

graphics/one_icon.jpg

Click the Format menu, and then click Conditional Formatting.

graphics/two_icon.jpg

Click Delete.

graphics/three_icon.jpg

Select the check box for the condition(s) you want to delete.

graphics/four_icon.jpg

Click OK.

graphics/09inf09.jpg



Show Me. Microsoft Office 2003
Show Me Microsoft Office 2003
ISBN: 0789730073
EAN: 2147483647
Year: 2002
Pages: 418

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net