• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Designing a Worksheet with Excel > Designing Conditional Formatting

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

Select a cell or range you want to conditionally format.

Click the Format menu, and then click Conditional Formatting.

Select the operator and values you want for condition 1.

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

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

Click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint