+ Reply to Thread
Results 1 to 6 of 6

Tick mark in cell

  1. #1
    Registered User
    Join Date
    07-29-2019
    Location
    Wales
    MS-Off Ver
    Office 365
    Posts
    68

    Tick mark in cell

    Hi,

    I would like a tick mark to appear in the cell I click in, or a "Y" its to speed up filling in a report,

    Cheers

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Tick mark in cell

    Place an "A" in "G1" for code to run on "Right Click", remove when not required.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-29-2019
    Location
    Wales
    MS-Off Ver
    Office 365
    Posts
    68

    Re: Tick mark in cell

    I'm new to excel - I can't get your suggestion to work. I'm thinking it's because I have a Yellow triangle against MACRO Security. I've checked enable all macros it doesn't go,

    Cheers

  4. #4
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Tick mark in cell


  5. #5
    Registered User
    Join Date
    01-15-2019
    Location
    Michigan
    MS-Off Ver
    2010
    Posts
    2

    Re: Tick mark in cell

    Check out the conditional formatting options

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,492

    Re: Tick mark in cell

    This has nothing to do with conditional formatting, Sondayl. Please start your own thread with a query instead of adding irrelevant posts to other threads. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Display a TRUE value as a tick mark
    By Trebor777 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-10-2018, 11:41 AM
  2. Excel report with X and tick mark
    By ashintoms in forum Excel General
    Replies: 3
    Last Post: 04-19-2015, 08:07 AM
  3. creat sum based on tick mark !
    By legolas in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 11-13-2014, 08:00 AM
  4. Using cell as checkbox (add tick mark)
    By ThePixie in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-05-2013, 12:02 AM
  5. Enter Tick Mark
    By lsmft in forum Excel General
    Replies: 6
    Last Post: 01-27-2008, 04:05 PM
  6. [SOLVED] what is 'tick mark' in corner of cell ?
    By Will in forum Excel General
    Replies: 1
    Last Post: 04-20-2006, 02:55 PM
  7. tick mark labels
    By Debrane in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 07-18-2005, 10:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1