?
Solved

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

Posted on 2004-04-14
3
Medium Priority
?
253 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 500 total points
ID: 10828988
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
What do responsible coders do? They don't take detrimental shortcuts. They do take reasonable security precautions, create important automation, implement sufficient logging, fix things they break, and care about users.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
Starting up a Project
Suggested Courses

777 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