Change the color of cells having formula.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,
Is it possible to change the color of the cells which has any type of
formula? I have tried with conditional formatting but not succeeded with it.
 
Hi Arup,

I don't know of a way with CF but you can do it by tapping
F5 click Special and check Formulas.
This will highlight all your formulas and you can then set
your formatting.

You can also use Ctrl+` (the symbol to the left of 1 at the
left of your keyboard. This is a toggle switch that will alternate
between displaying the formulas and their values.

HTH
Martin
 
Hi,
It was helpful though I was asking for the command which autometically
detects any formula and changes color of the cell like the conditional
formatting command
 
You need to create a UDF

Function HasFormula(rng as range)
If rng.Cells.Count = 1 Then
HasFormula = rng.IsFormula
End If
End Sub

and use that in the CF

=HasFormula(A2)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top