+ Reply to Thread
Results 1 to 4 of 4

Excel report with X and tick mark

  1. #1
    Registered User
    Join Date
    04-18-2015
    Location
    UK
    MS-Off Ver
    2010 and 2013
    Posts
    3

    Excel report with X and tick mark

    Need a quick fav,

    I need to create an excel sheet with a drop down list - Tick mark and cross sign mark and display that tick mark with green and cross sign mark with red color. i've tried inserting character 2715 and 2714 to get the signs.

    eg : Cell A1 - tick
    a2 - cross

    I then added two rules for each of those cells like

    Format cells that contain specific text containing A1 and gave fill with red
    Format cells that contain specific text containing a2 and gave fill with green

    I then added data validation and i can see a tick and cross in the drop downs but i don't find the color i need ..

    I also tried changing the text colors in A1 AND a2 earlier to see if colors but i dont find colors appearing after the pull list is populated.

    All i need is tick to show a green font and all the cross mark to be red or other way around..

    what may be wrong ?

    how to fix ?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Excel report with X and tick mark

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    04-18-2015
    Location
    UK
    MS-Off Ver
    2010 and 2013
    Posts
    3

    Re: Excel report with X and tick mark

    Ok, See the attached excel file > Both X and tick mark are in black even thou r




    What i need is X to show red and tick mark to show blue color when i drop the pull down list from Cell C2 and below members.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-25-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Excel report with X and tick mark

    Would this suffice?

    changed font to webdings
    a = tick
    r = cross

    add conditional formatting for specific text
    adjusted validation rule to have comments so user knows how to get the ticks/crosses.
    Attached Files Attached Files

+ 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. Tick mark to display word
    By DODGE in forum Excel General
    Replies: 5
    Last Post: 05-31-2011, 02:11 AM
  2. Enter Tick Mark
    By lsmft in forum Excel General
    Replies: 6
    Last Post: 01-27-2008, 04:05 PM
  3. [SOLVED] How can I put a tick/check mark in an Excel spreadsheet?
    By Amanda in forum Excel General
    Replies: 2
    Last Post: 07-21-2005, 07:06 AM
  4. Re: How can I put a tick/check mark in an Excel spreadsheet?
    By R.VENKATARAMAN in forum Excel General
    Replies: 1
    Last Post: 07-21-2005, 07:06 AM
  5. 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