formula's in cells

  • Thread starter Thread starter me2a-baa-baa-boo
  • Start date Start date
M

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.
 
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
 
Back
Top