Microsoft Office Tutorials and References
In Depth Information
USE GET.CELL TO HIGHLIGHT NON-FORMULA CELLS
To make use of this formula, follow these steps in Excel 2007:
1.
To defi ne a new name, select Formulas, Name Manager, New and use a
suitable name, such as HasFormula . In the Refers To box, type =GET.CEL
L(48,INDIRECT("RC",FALSE)) , as shown in Figure 20. Click OK. Click
Close. You use the New Name dialog to defi ne a name in Excel 2007.
Figure 20. You use the New
Name dialog to dei ne a name
in Excel 2007.
Select the cells to which you want to apply the conditional formatting.
2.
3.
Select Home, Conditional Formatting, New Rule. Choose Use a Formula
to Determine Which Cells to Format. In the lower half of the dialog type
=HASFORMULA , as shown in Figure 21. Click the Format button and choose
a format for the cell. Click OK.
Figure 21. You use the New
Format ing Rule dialog to set up
conditional format ing in Excel
2007.
 
Search JabSto ::




Custom Search