Matching colors in your reports

Wednesday 11 August 2021 @ 6:19 pm

I had a project this week where I had to replicate the look of a very colorful spreadsheet. It featured 4 different shades of green. Matching an existing color in a Crystal Report usually involves a fair amount of trial and error, but I can usually get close.  This time I was having a hard time matching a light green and it dawned on me that there might be a web site to identify colors.  I had just gone to the paint store with a chip of drywall and came home with a gallon of paint that exactly matched a faded wall color, so I figured the odds were good.

I did a quick search and found many free sites where you can upload an image file and click on a color to get the RGB / HEX / CMYK codes for that color.  I took screenshots of several spreadsheet cells, uploaded them and got instant matches. The customer was impressed and I didn’t have to do any guess work.

You can find a page full of sites with a search on “image color picker”.  I like these two in particular because you can put in a URL for an online image file as well as uploading an image. Not all the sites had that part working well.

UPDATE 8/11/2021:

I just heard from Adam Butt of APB reports, who pointed out that there is a color picker tool in most image editing programs, including the classic MS Paint, and Paint 3D. I have been using classic MS Paint forever and never paid attention to the eye dropper icon:

color picker icon

This lets you click anywhere in the image and gives you the color codes at that spot.

Leave a Reply

Recrystallize Pro

Crystal Reports Server