Formula
 

Good morning all,

I'm checking a spreadsheet prodcued by another person in the office.

Some of the values in the cells are created using a formula, others are hard
numbers inputted directly into those cells.

Is there a way of easily distinguishing between the two? Prefereably
through the use of an IF formula?


Thanks in advance,

Neil

Formula
 

HI,

in the menubar
Edit|Go to|Special|check the formulas check box|Ok

This will display the cells having formulas in them
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"Neil Pearce" wrote:

Good morning all,

I'm checking a spreadsheet prodcued by another person in the office.

Some of the values in the cells are created using a formula, others are hard
numbers inputted directly into those cells.

Is there a way of easily distinguishing between the two? Prefereably
through the use of an IF formula?


Thanks in advance,

Neil

Formula
 

Hi,
Here's another way, which will colour all cells that contain a formula.

1 Select Insert, Name, Define.

2 In the Define Name dialog box, enter the following in the 'Names in
workbook' box CellHasFormula

3 Then enter the following formula in the "Refers to" box
=GET.CELL(48,INDIRECT("rc",FALSE))

4 Click Add, and then OK.
5 Select all the cells to which you want to apply the conditional
formatting.
6 Select Format, Conditional Formatting
7 In the Conditional Formatting dialog box, select Formula Is from the
drop-down list, and then enter this formula in the adjacent box
=CellHasFormula
8 Click the Format button and select the type of formatting you want for the
cells that contain a formula, ie a red fill.
9 Click OK.
Dave

"Suleman Peerzade" wrote:

HI,

in the menubar
Edit|Go to|Special|check the formulas check box|Ok

This will display the cells having formulas in them
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"Neil Pearce" wrote:

Good morning all,

I'm checking a spreadsheet prodcued by another person in the office.

Some of the values in the cells are created using a formula, others are hard
numbers inputted directly into those cells.

Is there a way of easily distinguishing between the two? Prefereably
through the use of an IF formula?


Thanks in advance,

Neil