P
Peter McNamee
Hi All
I want to set up a conditional format such as if a cell contains any
formula it has one format and if it doesn't contain a formula it has
another format.
I have looked at the conditional formatting part of excel and it
doesn't seem to have this ability.
However I realised if I put a formula in that returned true if the
cell contained a formula then this would work.
I was then amazed not to be able to find any standard function in
excel which does this. In the end I wrote a VBA function to do this
but this isn't very satisfactory as I think it's too error prone.
Has any one got any solution using standard excel processes.
Also i often use sheets on manual calculation and I think this might
impact on any solution.
Cheers
Peter
I want to set up a conditional format such as if a cell contains any
formula it has one format and if it doesn't contain a formula it has
another format.
I have looked at the conditional formatting part of excel and it
doesn't seem to have this ability.
However I realised if I put a formula in that returned true if the
cell contained a formula then this would work.
I was then amazed not to be able to find any standard function in
excel which does this. In the end I wrote a VBA function to do this
but this isn't very satisfactory as I think it's too error prone.
Has any one got any solution using standard excel processes.
Also i often use sheets on manual calculation and I think this might
impact on any solution.
Cheers
Peter