conditional format question re values or formulas excel 2003

sorry, there is no regular function/formula that can tell the difference between a formula of an entry in a cell

I do remember seeing a similar question a while back, some-one offered a VBA or add-in solution, cant remember which. I will try and see if i can find the reference, maybe some-one else knows how to do it?

the problem is that excel looks at the results of a formula, not the formula itself. for instance, as far as the contents of a cell is concerned, excel sees exactlyy the same contents for =1+1 as it does for a cell that just contains 2

i get confused with the "" usage in the'formula is' entry box...

you only use "" if are using text. so it would be "text" or 10. but that formula, clever though it is, will not work anyway (to prove it to yourself, in any cell - say A1, type =100+55. then in B1 type in =left(A1,1). the answer will be 1 (the left-most digit of 155), not =, as you were expecting

See this link, it will tell you exactly how to do it:

http://www.techrepublic.com/article/...-excel/5766524

- Moo

Here's another way

If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.