Hello everyone,

Is this possible? I would like to add a conditional format to a cell
that highlights the cell if and only if a hardcoded text or number is
in the cell. If the cell has a formula in it, do nothing. I have
some code that does this, but I was hoping to add this to some cells
without using code. Thanks so much!

-Steph

Hi
you need at least a user defined function for checking if the cell
contains a formula. So AFAIK no chance without some code

--
Regards
Frank Kabel
Frankfurt, Germany

"Steph" schrieb im Newsbeitrag
om...
Hello everyone,

Is this possible? I would like to add a conditional format to a cell
that highlights the cell if and only if a hardcoded text or number is
in the cell. If the cell has a formula in it, do nothing. I have
some code that does this, but I was hoping to add this to some cells
without using code. Thanks so much!

-Steph