Excel color palette

[zookeepertx]

Hello all,
It used to be that you could right-click to show the Cell Color palette to change a cell's color and then grab the palette and drag the whole box down so it showed all the time. You could do the same thing with the Font Color palette. Now, you have to right-click and select directly from the displayed palette instead of having the palette already there to just choose from.
I have several worksheets that I have to go through and evaluate a large number of cells, one at a time, then decide what color to make the cell. Because there are so many cells to evaluate, it's kind of a (small) pain to have to ask for the palette every single time I need to change a cell's color. Is there a way to get that little box with the color palette to show all the time like you used to be able to do?
Conditional Formatting won't work because there is such a variance of reasons why a cell needs to be a particular color.

This little box is what I'm talking about.

(I hope this question is clear. I tend to "over-describe" things and confuse people when I'm typing/writing)

Thanks!

Jenny

 

[zookeepertx]

Re: 1 and 21
The top color and the 4th from the bottom have the same RGB's
No problem at all, I just noticed it when trying out the color palette.

Dangit they were the same! I forgot that I found that last evening & deleted the later one but forgot to post it here. Yesterday I was able to get the Hex values on each color. It was SO simple! Duhhhh... I should have known that! In comparison with the RGB values, the Hex values make absolutely NO sense at all! I get that the first 2 characters represent Red, middle 2 characters represent Green and the last 2 represent Blue. But I can't see any relation between the "amount" of - for example, the fifth color down (the bright yellow) - 255R vs 255G vs 0B. Okay - 0 Blue makes sense, but how can the rest be equally R and G?! It's YELLOW!
And then Bright Red vs pink - I totally understand Red being 255,0,0; makes complete sense. But Pink is 255,204,255. There's no Green or Blue in Pink!
(Someone has to wonder about this kind of stuff and I'm really good at it, LOL!)
And, on the subject of color mixing... What is Green doing in there anyway? The color wheel is based on Red, YELLOW and Blue. Green is between yellow and blue and is not a primary color. You have to mix those 3 - R, Y and B - to get whatever other colors you need, although white needs to be available to turn red into pink.
Okay, I'll stop now. Things like this just bother me. (This is where the OCD in my signature line might just come in. )

 

[MARK858]

And, on the subject of color mixing... What is Green doing in there anyway? The color wheel is based on Red, YELLOW and Blue. Green is between yellow and blue and is not a primary color. You have to mix those 3 - R, Y and B - to get whatever other colors you need, although white needs to be available to turn red into pink.

Primary Colors Are Red, Yellow and Blue, Right? Not Exactly

Primary colors are the blocks from which all other colors are built. But there's a lot more to know about them than the basic red, yellow and blue we learned about in kindergarten.

science.howstuffworks.com

 

[zookeepertx]

Primary Colors Are Red, Yellow and Blue, Right? Not Exactly

Primary colors are the blocks from which all other colors are built. But there's a lot more to know about them than the basic red, yellow and blue we learned about in kindergarten.

science.howstuffworks.com

NOOOO!!!! My whole life is a lie!!

 

[zookeepertx]

Another color value question, Mark.

The Hex values are various mixes of numbers AND letters. How do those combine to mean anything? I mean, the numbers make sense: The higher the number, presumably the more of that color is involved. But what do the letters mean?

 

[MARK858]

What Is the Hex Code? Everything You Need to Know

How do you identify a color? Find out how a short string of six characters can tell you all you need to know.

www.makeuseof.com

hex number/letter	Decimal number
0	0
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
A	10
B	11
C	12
D	13
E	14
F	15

 

[zookeepertx]

What Is the Hex Code? Everything You Need to Know

How do you identify a color? Find out how a short string of six characters can tell you all you need to know.

www.makeuseof.com

Dang, you're good!
Thanks for the info!

It's complicated but understandable.

Jenny

 

[MARK858]

Dang, you're good!

Not really just know from the past what is available online and where to find it again.
Happy it helped

 

[zookeepertx]

Not really just know from the past what is available online and where to find it again.
Happy it helped

I know where to find a bunch of stuff, but since I've never needed to be concerned about Hex, I'd have had NO clue whatsoever where to even start.
(Mostly, I come here to find out things. )

 

[Dan_W]

Hello. I'm so very sorry for taking so long to get back to you. I've been in the middle of moving but hopefully will start to settle down this weekend.

 

[Dan_W]

NOOOO!!!! My whole life is a lie!!

Honestly... I still haven't recovered from the whole 'Pluto is not a planet's fiasco... and now this..?!

On a slightly related noted, did you see the post in the Articles section re: the Javascript MixBox.js colour library? (Link) it looks amazing. I'm determined to get ChatGPT to convert it into VBA for me (which as little hand holding or corrections by me as possible)