Excel color palette

zookeepertx

Well-known Member
Joined
May 27, 2011
Messages
589
Office Version
  1. 365
Platform
  1. Windows
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. Cell Color.jpg

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

Thanks!

Jenny
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Hello Jenny,

Try Pressing down Alt Key and simultaneously clicking on the H key twice ,then once on the M key;

With the cell selected, press Alt+H+H+M keys. Then the Little palette of colors will pop up.


1673031348731.png
 
Upvote 0
Hello Jenny,

Try Pressing down Alt Key and simultaneously clicking on the H key twice ,then once on the M key;

With the cell selected, press Alt+H+H+M keys. Then the Little palette of colors will pop up.
Thanks for the suggestion, but the box still doesn't stay open after I select the color for that cell/cells. Before Microsoft "upgraded" stuff (which seems to almost never be a good thing, IMHO) you could open the little square palette box, drag it somewhere and it would just stay there. You could select a cell, choose a color, select another cell, choose a different color, etc. without the palette box disappearing. That way you didn't have to open the palette every time you wanted to color a cell.
 
Upvote 0
Tear off palette redundant in 2007 onward.
Thanks for the response, but I don't get what you're saying. I mean, I know what "redundant" means, but I don't know how it applies here.

I assume when you refer to "tear off palette" you mean the "floating" palette that I used to be able to move down into the working area so I could choose a color without having to call up the palette. But I need to know how to tear it off/make it float like I used to. I used to be able to do the font color palette, too.

It's just that, on various worksheets, I have to change cell colors and font colors so many times, it's just annoying to have to keep calling up the palette every time.

Any ideas would be greatly appreciated!

Jenny
 
Upvote 0
Well, after googling some more, it appears that this isn't possible. Other people are complaining about the same thing. (I've fussed about it for a long time; just never got around to posting, hoping for a solution till now).

Here's the article I found:

I'm bummed!

** IF ANYONE KNOWS DIFFERENT, I'D LOVE TO HEAR ABOUT IT!! **

Jenny
 
Upvote 0
Since first visiting this forum years ago, I have long since learnt that very, very few things are impossible.
I have also experienced this frustration. My 'solution' is a bit half-baked, but give me five minutes to dig it out.
 
Upvote 0
Ok - apologies for the delay - the laptop I'm using at the moment is staggeringly slow. I've started work on two solutions - one is simply to make a whole new color palette as an add-in (i.e., an XLAM file that you load an it would appear as a button in the ribbon that would sit on the worksheet. and would allow you to change the colour of selected cells.

RDGAozE.gif
 
Upvote 0
Sorry for the disjointed reply and the delay - I've been fighting a dozen wars with technology over the past hour.
So the above colour picker is a Work In Progress - there is an eyedropper and it works with palettes too, but there are a lot of little things I need to do to it to get it into some kind of working condition.

A little more developed, though a bit less flexible is a custom ribbon. This is something I made years ago, and essentially it fills a custom tab with two dozen buttons, each with a designated colour. This is probably more useful when you know thatyou have a certain colours that you need to keep selecting between. What colours are assigned to what button is entirely customizable too. I tried to dig out a file that demonstrates it, but it's on another computer, and I was conscious that my "give me five mins" comment was starting to look farcical.
 
Upvote 0
Thanks for the response, but I don't get what you're saying. I mean, I know what "redundant" means, but I don't know how it applies here.

I assume when you refer to "tear off palette" you mean the "floating" palette that I used to be able to move down into the working area so I could choose a color without having to call up the palette. But I need to know how to tear it off/make it float like I used to. I used to be able to do the font color palette, too.

It's just that, on various worksheets, I have to change cell colors and font colors so many times, it's just annoying to have to keep calling up the palette every time.

Any ideas would be greatly appreciated!

Jenny
Sorry. Tear off palette is the term used by MS for the floating palette.
Removed from Excel after the 2007 version.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top