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 2003:
To defi ne a new name, select Insert, Name Defi ne and use a suitable name,
such as HasFormula . In the Refers To box, type =GET.CELL(48,INDIR
ECT("RC",FALSE)) , as shown in Figure 18. Click Add. Click OK. You use
the Defi ne Name dialog to defi ne a name in Excel 2003.
1.
Part
I
Figure 18. You use the Dei ne Name dialog to dei ne a name in Excel 2003.
2.
3.
Select a range of cells.
Select Format, Conditional Formatting. Change the fi rst dropdown to
Formula Is. Type =HASFORMULA , as shown in Figure 19. Click the Format
button and choose a format for the cell. Click OK.
Figure 19. You can use the relatively obscure Formula Is version of conditional format ing.
 
Search JabSto ::




Custom Search