How can I tell in a cell on one sheet if a cell on another sheet is an input
value or a formula (e.g., 4 or =2*2)? I use the conditional formatting
=(HasFormula) when the cell that I am checking is on the same sheet but
conditional formating won't let me reference another sheet (I don't think)

Name the cell on the other sheet (select cell., do insertnamedefine)then
refer to the name in the formatting

=HASFORMULA(name_cell)

--
Regards,

Peo Sjoblom

(No private emails please)


"rrucksdashel" wrote in message
...
How can I tell in a cell on one sheet if a cell on another sheet is an
input
value or a formula (e.g., 4 or =2*2)? I use the conditional formatting
=(HasFormula) when the cell that I am checking is on the same sheet but
conditional formating won't let me reference another sheet (I don't think)

I get a #REF! when I enter this formula:
=HasFormula(TEST)
The cell TEST had 4 in it and I also had =2+2 in it andin both cases,
#REF!was the answer.

Also, can a cell reference be used instead of a name because the location
will change?

"Peo Sjoblom" wrote:

Name the cell on the other sheet (select cell., do insertnamedefine)then
refer to the name in the formatting

=HASFORMULA(name_cell)

--
Regards,

Peo Sjoblom

(No private emails please)


"rrucksdashel" wrote in message
...
How can I tell in a cell on one sheet if a cell on another sheet is an
input
value or a formula (e.g., 4 or =2*2)? I use the conditional formatting
=(HasFormula) when the cell that I am checking is on the same sheet but
conditional formating won't let me reference another sheet (I don't think)

You must have named the cell incorrectly, works for me as long as the UDF is
in the same workbook
No, you cannot use a cell reference unless you use a second cell to link to,
assume you put

=HASFORMULA(Sheet2!A2)

in Sheet1!IV1, then from the same sheet check for IV1

=IV1=TRUE

--
Regards,

Peo Sjoblom

(No private emails please)


"rrucksdashel" wrote in message
...
I get a #REF! when I enter this formula:
=HasFormula(TEST)
The cell TEST had 4 in it and I also had =2+2 in it andin both cases,
#REF!was the answer.

Also, can a cell reference be used instead of a name because the location
will change?

"Peo Sjoblom" wrote:

Name the cell on the other sheet (select cell., do
insertnamedefine)then
refer to the name in the formatting

=HASFORMULA(name_cell)

--
Regards,

Peo Sjoblom

(No private emails please)


"rrucksdashel" wrote in message
...
How can I tell in a cell on one sheet if a cell on another sheet is an
input
value or a formula (e.g., 4 or =2*2)? I use the conditional formatting
=(HasFormula) when the cell that I am checking is on the same sheet but
conditional formating won't let me reference another sheet (I don't
think)

Instead of referencing a cell as sheet95!e1
you can use a named cell don't know if that will really help you
or not. You could use a helper column on your current sheet.

You will also have a problem if your hasformula is refereenced
from your personal.xls workbook, it will have to be in the same workbook.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"rrucksdashel" wrote in message ...
How can I tell in a cell on one sheet if a cell on another sheet is an input
value or a formula (e.g., 4 or =2*2)? I use the conditional formatting
=(HasFormula) when the cell that I am checking is on the same sheet but
conditional formating won't let me reference another sheet (I don't think)

Maybe you can help me. I have the following:
In a blank workbook, I entered 4 in A1. Then in A2 I entered
=HasFormula (A1)
It gives me this
#NAME?

Also, if I name A1 as "Test" (without the quotes) and change the A1 in A2,
to Test, it gives me the same answer.

I have never been able to get this to work and really need for it to. Also,
you referred to a helper column. What is that and how would that help here?

"David McRitchie" wrote:

Instead of referencing a cell as sheet95!e1
you can use a named cell don't know if that will really help you
or not. You could use a helper column on your current sheet.

You will also have a problem if your hasformula is refereenced
from your personal.xls workbook, it will have to be in the same workbook.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"rrucksdashel" wrote in message ...
How can I tell in a cell on one sheet if a cell on another sheet is an input
value or a formula (e.g., 4 or =2*2)? I use the conditional formatting
=(HasFormula) when the cell that I am checking is on the same sheet but
conditional formating won't let me reference another sheet (I don't think)

HASFORMULA is a UDF and not built in, have you installed a function
called HASFORMULA anywhere?


--

Regards,

Peo Sjoblom


"rrucksdashel" wrote in message
...
Maybe you can help me. I have the following:
In a blank workbook, I entered 4 in A1. Then in A2 I entered
=HasFormula (A1)
It gives me this
#NAME?

Also, if I name A1 as "Test" (without the quotes) and change the A1 in A2,
to Test, it gives me the same answer.

I have never been able to get this to work and really need for it to.
Also,
you referred to a helper column. What is that and how would that help
here?

"David McRitchie" wrote:

Instead of referencing a cell as sheet95!e1
you can use a named cell don't know if that will really help you
or not. You could use a helper column on your current sheet.

You will also have a problem if your hasformula is refereenced
from your personal.xls workbook, it will have to be in the same
workbook.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"rrucksdashel" wrote in message
...
How can I tell in a cell on one sheet if a cell on another sheet is an
input
value or a formula (e.g., 4 or =2*2)? I use the conditional
formatting
=(HasFormula) when the cell that I am checking is on the same sheet
but
conditional formating won't let me reference another sheet (I don't
think)

Not to my knowledge. Is that an Add-In? How do I install it?

"Peo Sjoblom" wrote:

HASFORMULA is a UDF and not built in, have you installed a function
called HASFORMULA anywhere?


--

Regards,

Peo Sjoblom


"rrucksdashel" wrote in message
...
Maybe you can help me. I have the following:
In a blank workbook, I entered 4 in A1. Then in A2 I entered
=HasFormula (A1)
It gives me this
#NAME?

Also, if I name A1 as "Test" (without the quotes) and change the A1 in A2,
to Test, it gives me the same answer.

I have never been able to get this to work and really need for it to.
Also,
you referred to a helper column. What is that and how would that help
here?

"David McRitchie" wrote:

Instead of referencing a cell as sheet95!e1
you can use a named cell don't know if that will really help you
or not. You could use a helper column on your current sheet.

You will also have a problem if your hasformula is refereenced
from your personal.xls workbook, it will have to be in the same
workbook.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"rrucksdashel" wrote in message
...
How can I tell in a cell on one sheet if a cell on another sheet is an
input
value or a formula (e.g., 4 or =2*2)? I use the conditional
formatting
=(HasFormula) when the cell that I am checking is on the same sheet
but
conditional formating won't let me reference another sheet (I don't
think)

http://www.mvps.org/dmcritchie/excel...htm#hasformula

--

Regards,

Peo Sjoblom


"rrucksdashel" wrote in message
...
Not to my knowledge. Is that an Add-In? How do I install it?

"Peo Sjoblom" wrote:

HASFORMULA is a UDF and not built in, have you installed a function
called HASFORMULA anywhere?


--

Regards,

Peo Sjoblom


"rrucksdashel" wrote in message
...
Maybe you can help me. I have the following:
In a blank workbook, I entered 4 in A1. Then in A2 I entered
=HasFormula (A1)
It gives me this
#NAME?

Also, if I name A1 as "Test" (without the quotes) and change the A1 in
A2,
to Test, it gives me the same answer.

I have never been able to get this to work and really need for it to.
Also,
you referred to a helper column. What is that and how would that help
here?

"David McRitchie" wrote:

Instead of referencing a cell as sheet95!e1
you can use a named cell don't know if that will really help you
or not. You could use a helper column on your current sheet.

You will also have a problem if your hasformula is refereenced
from your personal.xls workbook, it will have to be in the same
workbook.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"rrucksdashel" wrote in
message
...
How can I tell in a cell on one sheet if a cell on another sheet
is an
input
value or a formula (e.g., 4 or =2*2)? I use the conditional
formatting
=(HasFormula) when the cell that I am checking is on the same
sheet
but
conditional formating won't let me reference another sheet (I
don't
think)