Reading RGB background color from cell

D

Don Wiss

From a macro, how do I read and set the background color of a cell? I am
not interested in its color index, but the RGB color number.

Thanks, Don <www.donwiss.com> (e-mail link at home page bottom).
 
D

David McRitchie

Hi Don,
But you will get that color only if have that exact color in your color
palette, for anything else when you try to set the value Excel will
pick the closest it can find in your 56 color palette.
http://www.mvps.org/dmcritchie/excel/colors.htm

Which I expects brings you back to what you are trying to avoid.
 
D

Don Wiss

But you will get that color only if have that exact color in your color
palette, for anything else when you try to set the value Excel will
pick the closest it can find in your 56 color palette.
http://www.mvps.org/dmcritchie/excel/colors.htm

Which I expects brings you back to what you are trying to avoid.

Yes. I was desiring a lighter color purple background. Our European parent
has this corporate identity thing. I was with a fellow programmer this
afternoon and I was telling him how I deleted the toolbar (see prior
thread), but left the menu. I happened to select the menu option that had
something to do with translate. In a flash it had changed the font on every
sheet, on the buttons, and it had changed all the colors. Which as you note
means they simply completely changed the color palette. (Fortunately it was
not the real system and I was able to close the now trashed workbook!)

Their colors tended towards pastels. Including a light purple. I never use
a purple background. Too dark for me. But I was thinking maybe the light
one would be useful.

Looking at your web page it appears that what I should be doing is to
change one of the palette colors. It's getting late tonight. I'll try to
study it later this weekend.

Thanks! Don <www.donwiss.com> (e-mail link at home page bottom).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top