Hints and tips home » Excel hints and tips » Colouring cells containing formulas
Colouring cells containing formulas
Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.
Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.
At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.
Added by Orok on 26th October 2006
More Excel hints and tips, like:
