I would like to use conditional formatting to highlight those cells
containing calculations. It appears that conditional formatting only
allows you to format cells that have specific results (equal to,
greater than, etc.) I just want to be able to visually distinguish
between those cells which contain formulas versus those which need to
be hard coded with numbers or text.

Thanks for you help!

You don't need conditional formatting:

Edit > Goto... > Special... > Formulas
and then apply the format
--
Gary''s Student - gsnu2007i

Alternate method so's you don't have to repeat the F5>Special every time you
enter new formulas in blank cells.

Copy/paste this UDF to a general module in your workbook.

Function IsFormula(cell)
IsFormula = cell.HasFormula
End Function

Select all existing cells and potential cells

Then in CF>Formula is: =IsFormula(A1)

Format to a pattern and OK your way out.


Gord Dibben MS Excel MVP

On Thu, 22 May 2008 09:37:54 -0700 (PDT), TiChNi <tcnichols@gmail.com> wrote:

>I would like to use conditional formatting to highlight those cells
>containing calculations. It appears that conditional formatting only
>allows you to format cells that have specific results (equal to,
>greater than, etc.) I just want to be able to visually distinguish
>between those cells which contain formulas versus those which need to
>be hard coded with numbers or text.
>
>Thanks for you help!

Very good suggestion! (this is one I will keep)
--
Gary''s Student - gsnu200787


"Gord Dibben" wrote:

> Alternate method so's you don't have to repeat the F5>Special every time you
> enter new formulas in blank cells.
>
> Copy/paste this UDF to a general module in your workbook.
>
> Function IsFormula(cell)
> IsFormula = cell.HasFormula
> End Function
>
> Select all existing cells and potential cells
>
> Then in CF>Formula is: =IsFormula(A1)
>
> Format to a pattern and OK your way out.
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 22 May 2008 09:37:54 -0700 (PDT), TiChNi <tcnichols@gmail.com> wrote:
>
> >I would like to use conditional formatting to highlight those cells
> >containing calculations. It appears that conditional formatting only
> >allows you to format cells that have specific results (equal to,
> >greater than, etc.) I just want to be able to visually distinguish
> >between those cells which contain formulas versus those which need to
> >be hard coded with numbers or text.
> >
> >Thanks for you help!
>
>

Thanks..........James, right?

Gord

On Thu, 22 May 2008 11:26:00 -0700, Gary''s Student
<GarysStudent@discussions.microsoft.com> wrote:

>Very good suggestion! (this is one I will keep)

We have many names.
--
Gary''s Student - gsnu2007i


"Gord Dibben" wrote:

> Thanks..........James, right?
>
> Gord
>
> On Thu, 22 May 2008 11:26:00 -0700, Gary''s Student
> <GarysStudent@discussions.microsoft.com> wrote:
>
> >Very good suggestion! (this is one I will keep)
>
>

OK


Gord

On Sat, 24 May 2008 06:26:01 -0700, Gary''s Student
<GarysStudent@discussions.microsoft.com> wrote:

>We have many names.