Forum Discussion
Transparency color in cells
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...
I copied the cells with values and text:
pasted it as a linked picture:
Then I setup a range of cells with the same row and height settings then put color on the cells that required some:
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%
78%
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:
https://www.rapidtables.com/convert/color/index.html
cheers
I wanted to overlay a line marking the current month in a Gantt Chart, the reply above gave me the idea. Create and fill in a column of any amount on a separate area and copy and paste special (as an image) on the worksheet you require and the image allows you to adjust its size and transparency. This may be useful in some circumstances.