Give the cells that contain the formula a bit of color to see

Do you have the experience of editing a spreadsheet that hasn't been used for a while, because it's careless to delete or overwrite cells that contain formulas? Or when you get someone else's data form, because you don't know which ones are calculated by the formula? Let me tell you a good idea: add the appropriate background color to the cell with the formula.

The first approach is to take advantage of the "positioning" feature and follow these steps:

1. Open the "position" command on the Edit menu;

2. In the dialog box, select the lower left corner of the "positioning condition" button, open the "Positioning Criteria" dialog box;

3. Select "Formula" and press "OK" to exit so that all cells containing the formula are selected;

4. Select the background color in the toolbar to be light green.

The disadvantage is that if you add or remove a formula, the cell does not add the background color or clear the background color as you would like. The other is the method that the printer repair network (http://www.dyj123.com) wants to emphasize, follow these steps:

1. Open the "define" subcommand in the name command of the Insert menu;

2. In the Definition Name dialog box, enter "cells with formulas," and then in the "point to Input" =get. CELL (48,indirect ("RC", FALSE)) ";

3. Click "Add" button, "OK".

4. Select the range of data you want to find and open the conditional formatting ... command on the Format menu.

5. In the Conditional Formatting dialog box, select the Drop-down list in the left column as "formula", in the right column, enter "= Cells with formulas" (excluding quotes). Click the Format button, and then select the Pattern tab in the Cell Format dialog box that pops up, and select the appropriate background color in the palette. We generally choose light and bright colors, such as light green.

6. Press OK to exit the Format Cells dialog box, and then press OK to exit the Conditional Formatting dialog box. The background of the cell with the formula applied has become light green and will never be resolved again.

This application is dynamic, as long as it is within the scope of the application to increase or reduce the formula, it can reflect the effect at any time.