9 replies
by borrim Accepted solution
by robo_dev Accepted solution
the only really weird way you could do this would be to create a striped jpg file and set it as the spreadsheet background....
of course it would not line up when you changed cell widths.
So create the sheet the way you want it, select it and copy to MS Paint. Save it as a jpg and make that your background (format>sheet>background)
by borrim Accepted solution
by Former member Accepted solution
http://www.geocities.com/davemcritchie/excel/colors.htm
Please post back if you have more problems or questions.
by borrim Accepted solution
by tonythetiger Accepted solution
by borrim Accepted solution
by dbhatoa Accepted solution
Hi,
I came across your thread located at:
I have a sheet with lots of % values and I'd like to display the cell value and colour the cell accordingly, i.e. if the cell value is 19.44% I'd colour 19.44% of the cell yellow.
Please can you explain the process a little more
Your help would be much appreciated.
by tonythetiger Accepted solution
you'd have to have a 10,000 characters-wide cell, and put in 1,944 characters in the cell. That's probably not feasible.
If it were me, I'd use a 20 characters-wide cell, each character representing 5%, so 19.44% would round to 20%, which would be 4 of the 20 characters.
If you send me a private email, I'd be happy to attach an example back to you.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending