View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Conditional Formating

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