F
Frank kabel
Hi
do you want to check if it a formula (and not a constant).
If yes you may use the following uDF in conditional format
public is_formula(rng as range)
is_formula=rng.hasformula
end function
Now in conditional format use
=IS_FORMULA(A1)
conditional formatting or is there a different way?
do you want to check if it a formula (and not a constant).
If yes you may use the following uDF in conditional format
public is_formula(rng as range)
is_formula=rng.hasformula
end function
Now in conditional format use
=IS_FORMULA(A1)
ground to change to a color. How do I do that with
conditional formatting or is there a different way?