In Excel for Microsoft 365 on Windows, select the cell or range, then go to Home > Fill Color and choose a color; use the arrow beside the paint-bucket icon to open the palette. For an exact color, choose More Colors and enter its RGB values. Excel’s cell-color picker selects colors for formatting, but it does not provide a general eyedropper for sampling any pixel on your screen.
What “color picker” means in Excel
People use “color picker” to mean a few different things: the palette for changing a cell’s fill, the controls for changing font or border color, a dialog for entering an exact color, or an eyedropper that samples a color from an image or another part of the screen. Excel includes the first three in its formatting tools. The eyedropper is a separate capability and is not part of the standard cell-color palette in Excel for Windows.
That distinction matters when following online instructions. A tutorial may show an eyedropper in PowerPoint or another Office app and imply the same button is available in Excel. Excel’s menus and features vary by app, so if you do not see an eyedropper in the Excel color menu, it is not simply hidden behind the cell palette. You can still match a color by entering its RGB values, or use another tool to identify those values first.
How to change a cell’s fill, font, or border color
For a background color, select one or more cells and use Home > Fill Color. Click the main part of the button to apply the currently displayed color; click its arrow to choose a different one. For text, use Home > Font Color. To change a border, open the arrow next to Home > Borders and choose a border color before applying the border. In each case, select the target cells first so the formatting goes where you intend.
The palette usually offers theme colors, standard colors, and recently used colors. Theme colors are organized around the workbook’s current theme, with lighter and darker variations. Choosing a theme color can help keep a workbook’s formatting consistent: if the workbook theme changes, formatting that uses theme colors can update with it. A custom RGB color is useful when you need a particular shade that is not in the palette, but it may not behave like a theme color when the theme changes.
To set more detailed cell formatting, select the cells and open Home > Format > Format Cells, then use the Fill tab for background options. On Windows, Ctrl+1 opens Format Cells; on Mac, use Command+1. The dialog is useful when you also want to set borders or number formats in the same place. It is not necessary for a basic fill-color change.
Choose an exact color with RGB values
When a design guide, chart, or brand specification gives you an RGB color, use the custom color dialog rather than trying to judge a close match by eye. Select the cells, open the Fill Color arrow, choose More Colors, and look for the custom color controls. In the Windows desktop dialog, enter the red, green, and blue values, each from 0 through 255, then confirm. You can use the same approach from the Font Color menu when the text itself needs the exact shade.
For example, the web-style color code #2F75B5 represents RGB values 47, 117, and 181. Entering those three numbers in the RGB controls produces that blue. Hexadecimal codes are common in websites and brand documents, but Excel’s desktop color dialog may not provide a hex entry field in every version or interface. If you see only RGB boxes, convert the hex code to RGB or use a trusted color tool to obtain the three decimal values.
Exact values are especially useful when several people edit the same workbook or when the spreadsheet needs to match a presentation or report. Keep the color specification somewhere accessible, such as a notes sheet, instead of relying on memory or a screenshot. That makes it easier to reproduce the color later and reduces small visual differences between worksheets.
Can Excel sample a color from an image?
Excel’s ordinary cell-fill and font-color menus do not offer a general-purpose eyedropper for sampling a pixel from anywhere on the screen. If the color you want appears in a picture, a website, or another application, first identify its RGB values with an appropriate color-sampling tool, then enter those values in Excel’s custom color dialog. On Windows, Microsoft PowerToys includes a Color Picker utility; its shortcut and settings can be configured in PowerToys, so check the utility’s current settings rather than assuming a shortcut is enabled.
Another option is to use an Office app that has an eyedropper for the object you are formatting, if that feature is available in your version, then read or reproduce the resulting color values for Excel. Do not assume an eyedropper shown in a PowerPoint tutorial will appear in Excel’s cell formatting menu. On a Mac, the built-in Digital Color Meter can identify screen colors; the precise workflow for entering the resulting values depends on the color controls in your Excel version.
Be aware that a sampled screen color can differ from the original source. Screen scaling, transparency, shadows, image compression, and display settings can affect the pixel you sample. If a brand guide supplies a formal RGB or other color specification, prefer that value over sampling a logo displayed on screen.
Excel for Mac and Excel for the web
On Excel for Mac, the basic task is similar: select the cells and use the fill, font, or border color controls on the Home tab. The palette and custom-color interface can look different from the Windows dialog, and available color-entry controls may depend on the Excel and macOS versions. Command+1 opens Format Cells on Mac; the Windows shortcut is Ctrl+1. If you need an exact RGB color, use the custom-color controls that your version presents and verify the applied shade in the sheet.
Excel for the web also provides cell fill and font color controls on the ribbon, but its menus and editing capabilities are not identical to the desktop app. If you cannot find a particular custom color control in the browser, open the workbook in the desktop version of Excel and use its color dialog. A workbook’s formatting can still be viewed in the browser even when a specific editing control is easier to access on desktop.
These differences are a reason to describe the app and platform when sharing instructions. “Click More Colors” is more useful when the reader knows whether the steps refer to Windows desktop, Mac, or the browser, since a label or dialog may differ.
When the displayed color does not change
If you apply a fill but the cell still looks unchanged, conditional formatting is a common cause. A conditional-formatting rule can apply a fill based on a cell’s value and make the displayed color differ from the manual fill you selected. Check Home > Conditional Formatting > Manage Rules to review rules that apply to the selection or worksheet. You can edit or remove a rule if appropriate, but first consider whether the color is intentionally communicating a status such as overdue, above target, or duplicate.
Other issues are simpler: the wrong range may have been selected, the color may have been applied to the font rather than the fill, or a border color may have been changed without applying a border. If cells are part of a formatted table, the table style can also affect their appearance. Check the selected cells, the relevant color button, and the table style before repeatedly applying a new shade.
When copying data, Excel may bring formatting along with the values. If you want to keep the destination’s existing colors, use a paste option that pastes values rather than all formatting. Conversely, if the goal is to reproduce the source’s appearance, use a paste option that includes formatting. If formatting seems inconsistent across cells, compare their conditional-formatting rules and table membership as well as their manually selected fill colors.
Using colors clearly and consistently
Color can make a worksheet easier to scan, but it should not be the only way information is communicated. For example, if red cells mean “late,” include a status word, icon, or explanatory key as well. This helps readers who cannot distinguish certain colors and makes the workbook clearer when printed in grayscale or viewed on a different display.
- Use a small, consistent set of colors for categories such as inputs, calculations, and warnings.
- Keep a legend near a color-coded table when the meaning might not be obvious.
- Check text contrast against the fill, especially for small text and pale or saturated backgrounds.
- Use conditional formatting for colors that should respond automatically to values, rather than manually recoloring cells every time the data changes.
- Save exact RGB values for colors that need to be reused across sheets or workbooks.
Excel also offers conditional-formatting color scales, which shade cells according to their values. To apply one, select the range and go to Home > Conditional Formatting > Color Scales. This is not the same as choosing one fixed fill color: the shade changes according to the rule and the values in the selected range. Color scales work well for showing relative highs and lows, but they can be misleading if readers do not understand what the scale represents.
Frequently Asked Questions
Where is the color picker in Excel?
Select the cells, then open Home > Fill Color for the background, or Home > Font Color for the text. Click the arrow beside the color button to see the palette and custom-color options.
How do I enter a hex color in Excel?
Some color dialogs may show a hex field, but it is not available in every Excel desktop interface. If yours shows only RGB controls, convert the hex code to its red, green, and blue values and enter those in More Colors.
Does Excel have an eyedropper?
The standard cell fill and font color menus in Excel do not include a general screen eyedropper. Use a separate color-sampling tool to find RGB values, then enter them in Excel’s custom color controls.
How do I copy a cell’s color to another cell?
Use Home > Format Painter to copy formatting, including the fill, from one cell or range to another. If you only want to reproduce a color, check its RGB values and apply that color without copying other formatting such as borders or number formats.
Why does my cell color change when I edit its value?
A conditional-formatting rule may be setting the visible fill according to the cell’s value. Review Home > Conditional Formatting > Manage Rules to see whether a rule applies and adjust it only if the color is not intended.
Which method should you use?
For an ordinary highlight, the Fill Color palette is quickest. For a precise, repeatable shade, use the custom color dialog and record the RGB values. For a screen color that is not already specified, use a separate sampler and enter its RGB result. For colors that should update as data changes, use conditional formatting rather than manually choosing a new fill each time. Matching the method to the job makes the result easier to maintain and helps other people understand what the colors mean.
Related
- Change All Caps to Lowercase in Excel: A Practical Guide
- Can You Change Border Color in Excel? Steps and Tips
- Can Git Track Excel Files? Version Control Explained
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel MATCH Function: Syntax, Examples, and Common ErrorsIn Excel, MATCH is a function—not a separate statement—that returns the position of a value in a one-dimensional…
- Excel SEQUENCE Examples for Numbers, Dates, and MoreExcel’s SEQUENCE function creates a spill range of consecutive numbers or other values: enter =SEQUENCE(5) in a blank…
- Excel FIND Function: How to Find Text Within a StringIn Excel, use FIND to locate text inside a string and return the position where it begins. For…
- XLOOKUP Example Table: Formulas, Results, and Tips in ExcelWith product IDs in A2:A6, prices in C2:C6, and the ID to find in E2, use =XLOOKUP(E2,A2:A6,C2:C6,"Not found").…
- Excel Date Format Formulas: TEXT, DATEVALUE, and MoreTo display a date as text with an Excel formula, use TEXT; with a date in A2, =TEXT(A2,"mmmm…
- Calculating Hours Worked in Excel: Formulas & TipsTo calculate hours worked in Excel, put a shift’s start time in A2 and end time in B2,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.