There is a nifty 'Eyedropper' tool present in Powerpoint 2013. Does anybody know if the same can be enabled / activated or is it present in Excel 2013.
There are multiple ways to do this.
One way is within Excel to find out a color by going to
- Page Layout and on the Themes menu selecting Colors, and then
- selecting Customize Colors, and then
- whichever color you want to use.
- You can click on "More Colors" underneath it and find out the RGB levels and then manually put that in for other shapes you want.
OR, easier still, you can
- copy/paste whatever you want from Excel into Powerpoint and then
- use the eyedropper in Powerpoint on it to select the color, and then
- go to Fill/More Colors and find out what the RGB levels are for it and then manually use that in Excel or other MS programs.
Use Pixie to tell you the RGB values and type manually into Excel's Custom Colors dialog.
- Open Pixie and hover mouse over desired color
- Open Custom Color Dialog in Excel and type the RGB value in
Pixie with Excel example:
There is no eye dropper tool available. Ways to replicate a colour to another cell include.
1) Clicking the drop down box at the side of the paint pot icon. Click 'more colours'. Click the 'custom' tab. Note down the colour model reference numbers. Next select the cell that you want this colour to be applied to, follow the same process and then when in the 'custom' colour tab type in the reference numbers you had noted earlier.
2) right click the coloured cell and click 'copy'. Next go to the new cell, right click and select 'paste special'. Then either click the 'formatting icon' or simply type the letter 'R'
You cannot. But, if you have to use many colors you can try my suggestion below:
Get the screenshot of the area you want to get the colors (printscreen [PRT SC] key)
Paste into Paint.
For each specific color:
Use eyedropper tool in Paint
Click the color
Click "Edit colors" in toolbar
Add the color into "Custum colors" (use tab to switch to the group and use arrow keys to locate an empty area and press "Add to Custom Colors")
Now you have all the colors in custom colors (maximum 16).
But, unfortunately, you cannot use this Windows standard(!) color dialog box in Excel (maybe or hopefully in the future).
You have to open Paint and Excel side by side and enter the color's RGB (Red, Green, Blue) values by looking it in Paint by clicking "Edit colors" in toolbar and clicking the specific color in "Custom colors"