Scott in Phoenix
New Member
- Joined
- Mar 5, 2002
- Messages
- 13
Hi!
Love the new board. This BB client is awesome - used it before. I like!
QUESTION:
How can I tell if a cell contains a formula or if it contains text? This is driving me NUTS!
Any functions I try all look at the VALUE of the cell, rather than the CONTENTS of the cell. I need to be able to differentiate between cells that contain text, and cells that have a formula that references the text.
I need to be able to do this via a formula or function, so that I can apply Conditional Formatting to the cells that contain the actual text.
Can anybody help??
Thanks in advance.
Scott
Love the new board. This BB client is awesome - used it before. I like!
QUESTION:
How can I tell if a cell contains a formula or if it contains text? This is driving me NUTS!
Any functions I try all look at the VALUE of the cell, rather than the CONTENTS of the cell. I need to be able to differentiate between cells that contain text, and cells that have a formula that references the text.
I need to be able to do this via a formula or function, so that I can apply Conditional Formatting to the cells that contain the actual text.
Can anybody help??
Thanks in advance.
Scott