Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

colorize cell in rowset of listview... based percentage

Posted on 2009-05-01
2
Medium Priority
?
191 Views
Last Modified: 2012-05-06
see the image of my listview...
I want colorize each cells in rowset based the percentage in cells, how to? is possible?

for example:
if the percntage is 50% colorize half cell
if the percentage is 25% colorize 1/4 of cell
....

ecc

i use this to insert percentage:
ITM.SubItems(5) = Format((VALORE_3 / VALORE_1 * 100), "#,##0.00")
Immagine1.JPG
0
Comment
Question by:luca2009
2 Comments
 
LVL 2

Accepted Solution

by:
Death_Rat earned 1500 total points
ID: 24282693
WOW! that would be so neat if possible, unfortunately the cells are set on a way that it is all or nothing.

Check this link for more ideas

http://www.microsoft.com/technet/scriptcenter/resources/qanda/apr07/hey0427.mspx

Please let me know if you figure something else.
0
 

Author Comment

by:luca2009
ID: 24282752
Hi Death_Rat, tks for sugestion ...
but i see is a sheet.. iwant to colorize cells in listview(?!)
Have a code foor tath?
Tks.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month21 days, 3 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question