LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
x axis tick mark labels Lou T Charts and Charting in Excel 1 November 19th 08 02:39 PM
Tick Mark Label funkev123 Charts and Charting in Excel 2 October 14th 08 10:07 PM
not able to see tick mark label e57 Charts and Charting in Excel 4 August 29th 08 02:22 AM
How can I add active tick mark/check mark boxes in excel? gerberelli Excel Discussion (Misc queries) 2 May 3rd 08 05:16 PM
tick mark labels Debrane Charts and Charting in Excel 9 July 19th 05 02:53 AM


All times are GMT +1. The time now is 12:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"