Solved

How to color the cells in a datacolumn? Vb.net

Posted on 2004-04-14
3
240 Views
Last Modified: 2010-04-17
Hi,
    I am new to vb.net, and I have a question regarding how to color-code the cells in a dataset.  I have 2 tables in a dataset: revenue and expense.  Now what I need is to color the cells based on their values.
   This is an example of how the revenue table looks like:

                                   1999                       2000                2001
Shoes                           97.5                        55.6                  78.5
Jewelry                        105.1                      ------                 97.5
Clothes                         -----                       15.5                  14.8
bags                             45.8                        -----                  25.6

   The dashes means that there are no data available.  Now my problem is to color the fields according to their values.  For example, for year 2001, I need to color the field with highest value to be red = RGB(255, 0, 0) and the lowest value to be black = RGB(0, 0, 0).  Then the rest distribute the color evenly.
I tried to use the paint method from here, but that only work if you color the cell based on value range, HOW CAN I LOOP THROUGH THE COLUMN AND COLOR BASED ON THEIR VALUE?
    Thanks in advance!
0
Comment
Question by:iamnotexpert
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 125 total points
ID: 10828988
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …

738 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