Show a tick mark for a positive test result
 

I need to know how to show a tick mark in a cell when my formula evaluating
data is correct. I have the formula working with an X and I can manually add
a tick mark to the cell but I need a formula to insert the tick.

Thanks for the Help!
--
JPS

Show a tick mark for a positive test result
 

I have the formula working with an X ..
Amend your formula to return a lower case "b" instead of an "X", then use
Marlett font for the formula cell(s). The "b"'s will appear as tick marks.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"JPS" wrote:
I need to know how to show a tick mark in a cell when my formula evaluating
data is correct. I have the formula working with an X and I can manually add
a tick mark to the cell but I need a formula to insert the tick.

Show a tick mark for a positive test result
 

Max,
Works but when I format the range, I am getting other symbols if the value
is not the tick. Is there a way to format the cells to Marlett only when the
resultant value is the tick?

JPS


"Max" wrote:

I have the formula working with an X ..
Amend your formula to return a lower case "b" instead of an "X", then use
Marlett font for the formula cell(s). The "b"'s will appear as tick marks.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"JPS" wrote:
I need to know how to show a tick mark in a cell when my formula evaluating
data is correct. I have the formula working with an X and I can manually add
a tick mark to the cell but I need a formula to insert the tick.

Show a tick mark for a positive test result
 

Hi,
If you are using excel 2007, go to conditional formating, Icon Sets and
there you have your tick, it will show up only if there is a value , but you
can set up with different conditions

"JPS" wrote:

Max,
Works but when I format the range, I am getting other symbols if the value
is not the tick. Is there a way to format the cells to Marlett only when the
resultant value is the tick?

JPS


"Max" wrote:

I have the formula working with an X ..
Amend your formula to return a lower case "b" instead of an "X", then use
Marlett font for the formula cell(s). The "b"'s will appear as tick marks.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"JPS" wrote:
I need to know how to show a tick mark in a cell when my formula evaluating
data is correct. I have the formula working with an X and I can manually add
a tick mark to the cell but I need a formula to insert the tick.

Show a tick mark for a positive test result
 

I am using 2003... Any suggestion?
--
JPS


"Eduardo" wrote:

Hi,
If you are using excel 2007, go to conditional formating, Icon Sets and
there you have your tick, it will show up only if there is a value , but you
can set up with different conditions

"JPS" wrote:

Max,
Works but when I format the range, I am getting other symbols if the value
is not the tick. Is there a way to format the cells to Marlett only when the
resultant value is the tick?

JPS


"Max" wrote:

I have the formula working with an X ..
Amend your formula to return a lower case "b" instead of an "X", then use
Marlett font for the formula cell(s). The "b"'s will appear as tick marks.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"JPS" wrote:
I need to know how to show a tick mark in a cell when my formula evaluating
data is correct. I have the formula working with an X and I can manually add
a tick mark to the cell but I need a formula to insert the tick.

Show a tick mark for a positive test result
 

Hi,
not at this point I have 2003 at home, if you don't get an answer before I
will come back to you

"JPS" wrote:

I am using 2003... Any suggestion?
--
JPS


"Eduardo" wrote:

Hi,
If you are using excel 2007, go to conditional formating, Icon Sets and
there you have your tick, it will show up only if there is a value , but you
can set up with different conditions

"JPS" wrote:

Max,
Works but when I format the range, I am getting other symbols if the value
is not the tick. Is there a way to format the cells to Marlett only when the
resultant value is the tick?

JPS


"Max" wrote:

I have the formula working with an X ..
Amend your formula to return a lower case "b" instead of an "X", then use
Marlett font for the formula cell(s). The "b"'s will appear as tick marks.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"JPS" wrote:
I need to know how to show a tick mark in a cell when my formula evaluating
data is correct. I have the formula working with an X and I can manually add
a tick mark to the cell but I need a formula to insert the tick.

Show a tick mark for a positive test result
 

Hi JPS
How about Setting the font colour to white in that column and then using
conditional formatting Cell value is: select Equal to and type b in the
next window, press Format and use colour font.
HTH
John
"JPS" wrote in message
...
I am using 2003... Any suggestion?
--
JPS


"Eduardo" wrote:

Hi,
If you are using excel 2007, go to conditional formating, Icon Sets and
there you have your tick, it will show up only if there is a value , but
you
can set up with different conditions

"JPS" wrote:

Max,
Works but when I format the range, I am getting other symbols if the
value
is not the tick. Is there a way to format the cells to Marlett only
when the
resultant value is the tick?

JPS


"Max" wrote:

I have the formula working with an X ..
Amend your formula to return a lower case "b" instead of an "X", then
use
Marlett font for the formula cell(s). The "b"'s will appear as tick
marks.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"JPS" wrote:
I need to know how to show a tick mark in a cell when my formula
evaluating
data is correct. I have the formula working with an X and I can
manually add
a tick mark to the cell but I need a formula to insert the tick.

Show a tick mark for a positive test result
 

Private Sub Worksheet_Calculate()
Dim Cell As Range
Const WS_RANGE As String = "B:B" 'adjust to suit
On Error GoTo CleanUp
Application.EnableEvents = False
For Each Cell In Me.Range(WS_RANGE).Cells
If Cell.Value = "x" Then
With Cell
.Font.Name = "Marlett"
.Font.Size = 10
.Value = "b"
End With
End If
Next Cell
CleanUp:
Application.EnableEvents = True
End Sub


Gord Dibben MS Excel MVP

On Tue, 23 Dec 2008 05:27:01 -0800, JPS
wrote:

I am using 2003... Any suggestion?

Show a tick mark for a positive test result
 

Bad suggestion.

Clears out the formulas in cells with an "x"


Gord

On Tue, 23 Dec 2008 11:19:16 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Private Sub Worksheet_Calculate()
Dim Cell As Range
Const WS_RANGE As String = "B:B" 'adjust to suit
On Error GoTo CleanUp
Application.EnableEvents = False
For Each Cell In Me.Range(WS_RANGE).Cells
If Cell.Value = "x" Then
With Cell
.Font.Name = "Marlett"
.Font.Size = 10
.Value = "b"
End With
End If
Next Cell
CleanUp:
Application.EnableEvents = True
End Sub


Gord Dibben MS Excel MVP

On Tue, 23 Dec 2008 05:27:01 -0800, JPS
wrote:

I am using 2003... Any suggestion?

Show a tick mark for a positive test result
 

You can insert a tick mark inside the formula, and ignore the cell format,

something like :

=IF(A10,"ˆš","")

Regards
Bosco


"JPS" wrote:

I need to know how to show a tick mark in a cell when my formula evaluating
data is correct. I have the formula working with an X and I can manually add
a tick mark to the cell but I need a formula to insert the tick.

Thanks for the Help!
--
JPS