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

Chapter 13. Formatting the Sheet > Applying Conditional Formatting

Applying Conditional Formatting

If a cell or range of cells contains data that you want to highlight if certain conditions are met, you can use conditional formatting.

To apply conditional formatting to a cell or range of cells:

1.
Select the cells to format (Figure 13.23).

Figure 13.23. Select the cell or cells to format.


2.
From the Format menu, choose Conditional Formatting.

3.
Use the pull-down lists and the edit box to set the first condition (Figure 13.24).

Figure 13.24. Set the condition in the Conditional Formatting dialog box.


4.
Click the Format button to choose the formatting that wil be applied if the condition is met (Figure 13.25).

Figure 13.25. Choose the conditional formatting.


5.
Click OK when you have finished, or click the Ad button to add another condition (Figure 13.26).

Figure 13.26. Click Add to set more conditions.


The conditions are applied (Figure 13.27).

Figure 13.27. The first condition applied.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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