color a cell with a formula in it?
I used this UDF and it work like a charm, however... whenever I use this
function in a conditional format.. something funny happen... When I refer
from a different sheet to a cell on this sheet with the conditional format
in... it does not work... excell wrongly put the stuff in the refered
sheet... hope my explanation make sence!
"Sandy" wrote:
Add a User Defined Funtion UDF
In a code module. In Excel, Alt-F11 to the VBIDE, insert a module,
InsertModule, and paste that code in.
Function IsFormula(rng As Range)
IsFormula = rng.HasFormula
End Function
Then then add that in the CF formula
=IsFormula(A10)
HTH
"Ken" wrote:
Is it possible to have excel change the color of a cell with a formula in it?
|