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!
A neat trick I've used is to convert a numberic value into a barline representation in a cell.
The formula is very simple, in B1:
Please Login or Register to view this content.
=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.
Last edited by JBeaucaire; 04-30-2009 at 03:09 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks