k vba project, and add this
> function
>
> Function HASFORMULA(rngCell As Range) As Boolean
>
> HASFORMULA = rngCell.HASFORMULA
>
> End Function
>
> In your conditional format rule, use =HASFORMULA(A1)
>
> Regards,
>
> Sam
>
>
>
>
>
> On Thu, Oct
Conditional Formatting Highlight of Changed Cells
I have a large spreadsheet where users occasionally will overwrite the
builtin formula with a value. I would like Conditional Formatting to
highlight these cells that were changed from a formula to a numeric
value. My first shot in Cell “A1” was a c
