+ Reply to Thread
Results 1 to 2 of 2

Substitute text for an image.

  1. #1
    Registered User
    Join Date
    03-08-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    11

    Substitute text for an image.

    Hi,

    I have a spreadsheet that is a check list/survey, asking users to rate 0-5 with 5 being the best and 0 being poor, when filled in with a number I want the cells to automatically be replaced with a visual representation of the score, in this case a coloured bar.

    Is it possible to substitute text with an image? How?

    Regards
    Ben
    Last edited by benyates1; 05-08-2009 at 12:56 PM. Reason: Maked as solved!

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Substitute text for an image.

    A neat trick I've used is to convert a numberic value into a barline representation in a cell.
    Please Login or Register  to view this content.
    The formula is very simple, in B1:
    =REPT("|",INT(A1/10))

    Format that cell as BOLD, Font=Arial, and Color=Blue. Looks pretty cool.

    You can then apply some additional conditional formatting so that the closer the bar gets to the key number the more vibrant the color...all the way to RED if it passes the threshold.
    Attached Files Attached Files
    Last edited by JBeaucaire; 04-30-2009 at 03:09 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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