View Single Post
  #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.