Transparency color in cells

%3CLINGO-SUB%20id%3D%22lingo-sub-354818%22%20slang%3D%22en-US%22%3ETransparency%20color%20in%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354818%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20the%20transparency%20color%20in%20a%20cell%20to%20match%20colors%20from%20a%20PowerPoint%20slide.%26nbsp%3B%20I%20have%20the%20colors%20chosen%20but%20can't%20find%20where%20I%20can%20change%20the%20percentage%20transparent.%20I%20found%20gradient%20but%20not%20plain%20transparency.%26nbsp%3B%20%26nbsp%3BI%20have%20Excel%202016%20-%20where%20would%20it%20be%20if%20it%20can%20do%20that%3F%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPowerPoint%20-%20color%20243%2C188%2C169%20with%2066%25%20transparency%3B%20color%20151%2C185%2C%20255%20with%2078%25%20transparency%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-354818%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-356955%22%20slang%3D%22en-US%22%3ERe%3A%20Transparency%20color%20in%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-356955%22%20slang%3D%22en-US%22%3EI%20don't%20believe%20it's%20possible%20to%20set%20transparency%20in%20Excel.%20Furthermore%2C%20I%20don't%20think%20it%20would%20be%20much%20use%20as%20colours%20vary%20between%20monitors%20and%20computers.%20I%20would%20make%20yellow%20look%20like%20yellow%20and%20blue%20look%20like%20blue%20etc.%20Use%20Microsoft's%20themes%20or%20Web%20safe%20colours%20where%20possible.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2742337%22%20slang%3D%22en-US%22%3ERe%3A%20Transparency%20color%20in%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2742337%22%20slang%3D%22en-US%22%3EI%20can%20understand%20that%20matching%20different%20monitor%20colors%20is%20a%20challenge%2C%20but%20the%20reply%20that%20indicates%20that%20changing%20the%20transparency%20of%20cell%20fill%20colors%20in%20Excel%20is%20not%20useful%20is%20just%20not%20helpful.%20When%20I%20want%20to%20highlight%20a%20cell%20in%20a%20spreadsheet%2C%20I%20like%20to%20use%20red%20as%20a%20strong%20flag%20that%20something%20needs%20to%20be%20done.%20When%20I%20fill%20the%20cell%20with%20red%2C%20the%20fill%20is%20so%20dark%20that%20it%20becomes%20hard%20to%20read.%20I%20would%20really%20like%20to%20have%20a%20red%20fill%20color%20that%20was%20more%20transparent%20so%20that%20the%20text%20could%20be%20read%20easily.%20The%20fact%20that%20there%20is%20such%20limited%20control%20over%20the%20transparency%20of%20fill%20colors%20in%20the%20current%20version%20of%20Excel%20is%20sad.%20More%20than%205000%20people%20have%20looked%20at%20this%20question%2C%20so%20it%20is%20clearly%20something%20that%20would%20be%20useful.%20Microsoft%20-%20please%20consider%20an%20option%20that%20allows%20darker%20cell%20fill%20colors%2C%20not%20shape%20fill%20colors%2C%20to%20be%20modified%20so%20text%20can%20be%20easier%20to%20read.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2742504%22%20slang%3D%22en-US%22%3ERe%3A%20Transparency%20color%20in%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2742504%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1152992%22%20target%3D%22_blank%22%3E%40periodoc52%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWouldn't%20a%20transparent%20dark%20red%20just%20be%20a%20lighter%20red%3F%3C%2FP%3E%0A%3CP%3EAlternatively%2C%20you%20can%20use%20a%20contrasting%20font%20color.%20White%20text%20on%20a%20dark%20red%20background%2C%20for%20example.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need the transparency color in a cell to match colors from a PowerPoint slide.  I have the colors chosen but can't find where I can change the percentage transparent. I found gradient but not plain transparency.   I have Excel 2016 - where would it be if it can do that?    

 

PowerPoint - color 243,188,169 with 66% transparency; color 151,185, 255 with 78% transparency

 

thanks!

 

 

 

4 Replies
I don't believe it's possible to set transparency in Excel. Furthermore, I don't think it would be much use as colours vary between monitors and computers. I would make yellow look like yellow and blue look like blue etc. Use Microsoft's themes or Web safe colours where possible.
I can understand that matching different monitor colors is a challenge, but the reply that indicates that changing the transparency of cell fill colors in Excel is not useful is just not helpful. When I want to highlight a cell in a spreadsheet, I like to use red as a strong flag that something needs to be done. When I fill the cell with red, the fill is so dark that it becomes hard to read. I would really like to have a red fill color that was more transparent so that the text could be read easily. The fact that there is such limited control over the transparency of fill colors in the current version of Excel is sad. More than 5000 people have looked at this question, so it is clearly something that would be useful. Microsoft - please consider an option that allows darker cell fill colors, not shape fill colors, to be modified so text can be easier to read.

@periodoc52 

Wouldn't a transparent dark red just be a lighter red?

Alternatively, you can use a contrasting font color. White text on a dark red background, for example.

@Always-Learning 

 

I copied the cells with values and text:

Yea_So_1-1631406568822.png

pasted it as a linked picture:

Yea_So_2-1631406662047.png

Then I setup a range of cells with the same row and height settings then put color on the cells that required some:

Yea_So_5-1631407389251.png

 

then i copied the cells with colore pasted them as linked image as well and overlaid the  image with the color on top of the image with values then adjusted the transparency

68%

Yea_So_0-1631408899778.png

 

78%

Yea_So_0-1631408453732.png

 

and while you're making a presentation, you can probably change the values in excel and it will probably propagate in power point since its a linked image to the excel worksheet!

here is the color converter site:

Color code converter | color conversion (rapidtables.com)

Yea_So_8-1631407540529.png

 

cheers