| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| x axis tick mark labels | Charts and Charting in Excel | |||
| Tick Mark Label | Charts and Charting in Excel | |||
| not able to see tick mark label | Charts and Charting in Excel | |||
| How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
| tick mark labels | Charts and Charting in Excel | |||
Linear Mode
