formula's in cells

[me2a-baa-baa-boo]

is there a way to highlight a cell if it is an input and
not a formula? I would like to view an entire spreadsheet
on my screen and easily see which cells are inputs and
which cells have formula's. any help is appreciated. thank
you.

 

[Frank Kabel]

Hi
try the following:
- add the following UDF to one of your modules:
Function is_formula(rng) As Boolean
is_formula = rng.HasFormula
End Function

Now do the following
- select your cells for formating (assume you start in cell A1)
- Goto 'Format - Conditional Format'
- In the conditional format dialog enter the formula:
=NOT(Is_formula(A1))
- choose a format

 

[Leo Heuser]

One way.
Select the range in question and press <F5>