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:

• LARGE and SMALL functions and their uses
• Move data worksheet to worksheet
• Entering text in Multiple Worksheets