To put color in an Excel cell, select the cell or range, open the Home tab, and use the arrow beside Fill Color (the paint-bucket icon) to choose a shade. Excel applies that background color immediately. You can color one cell, several cells, or a larger range this way, and remove the fill later without deleting the cell’s contents.
What You’ll Need
- Microsoft Excel for Microsoft 365 on Windows, or Excel for Mac or the web if that is where you work.
- A workbook with the cells you want to format. You do not need a formula, add-in, or special setup.
- If you want an exact brand or project color, its RGB or hexadecimal color value is helpful, but not required.
Step-by-Step
- Select the cell or cells. Click a single cell to color it. To select a block, click the first cell and drag to the last. You can also click the first cell, hold Shift, and click the last cell in the range. To select separate cells that are not next to each other, hold Ctrl on Windows while clicking each one; on Mac, hold Command. Check the selection outline before choosing a color, especially if the sheet contains nearby data.
- Open the Home tab. On the Excel ribbon, click Home. Find the paint-bucket-shaped Fill Color control in the Font group. The control usually shows a colored line beneath the bucket, indicating the most recently used fill. The button itself may apply that displayed color immediately, so use its small drop-down arrow when you want to choose a different shade.
- Choose a standard color. Click the arrow beside Fill Color to open the color palette. Select a color under Theme Colors or Standard Colors. Theme colors are coordinated with the workbook’s theme; choosing a theme color can help keep a report visually consistent. Excel fills the selected cell or range as soon as you click a color. Click another shade if you want to change it.
- Pick a custom color if needed. In the palette, choose More Colors to open the color dialog. Depending on your Excel version, you can select a shade visually or enter specific color values, such as RGB values. On supported versions, the dialog may also accept a hexadecimal value. Confirm the selection with OK. The custom shade is applied to the cells that were selected before you opened the palette.
- Check the result and readability. Look at the cell text against the new background. If the text is hard to read, choose a lighter fill, or change the font color using the arrow beside Font Color (the A icon with a colored underline). Fill Color changes the cell background; Font Color changes the characters. They are separate settings, so changing one does not automatically change the other.
- Apply the same color elsewhere. Select another cell or range and choose the same shade from the Fill Color palette. For a quick copy of the complete cell formatting, select a cell that already looks right, click Home > Format Painter, then click or drag over the destination cells. Format Painter can copy more than the fill, including font and border formatting, so use the palette instead if you want to copy only the background color.
- Remove a fill if you change your mind. Select the colored cell or range, open the arrow beside Fill Color, and choose No Fill. This removes the background fill while keeping the cell’s value, formula, and other formatting. If you only just applied the color, you can also use Ctrl+Z on Windows or Command+Z on Mac to undo that action.
On Excel for Mac, the same basic process is available from the Home tab using the Fill Color paint-bucket control and its palette. The ribbon layout can differ slightly by version or window size, so look for the bucket icon if the control is not in the same position. In Excel for the web, select the cells, open Home, and use the Fill Color control; some color-dialog options may be more limited than in the desktop app.
Common Mistakes
- Clicking the bucket instead of its arrow. The main Fill Color button generally repeats the currently displayed color. If it applies the wrong shade, undo it or select No Fill, then use the arrow to choose the intended color.
- Confusing fill and font color. A colored underline beneath the A icon is for text, not the cell background. Use the paint bucket to color the cell itself. If the text disappears against the fill, adjust the font color separately.
- Selecting the wrong range. A selection can include extra rows or columns if you drag too far. Before applying color, check the highlighted outline and the Name Box to confirm which cell or range is selected. Undo immediately if you see color appear in unintended cells.
- Expecting color to change the cell’s value. Fill is formatting only. It does not alter a number, date, formula, or text, and it does not affect a calculation. If a color is meant to communicate a status, keep the actual status in the cell too, rather than relying on color alone.
- Assuming a color will look identical everywhere. A custom shade can appear slightly different on another display or when printed. Theme colors may also change if someone changes the workbook theme. For important documents, check the workbook on the intended screen or in print preview.
Tips
- Use a small, consistent palette. Assign a few colors clear meanings, such as pale yellow for items to review and pale green for completed entries. Reusing the same shades makes a worksheet easier to scan than coloring each cell differently.
- Choose readable contrast. Dark text usually works well on pale fills. If you use a dark background, choose a light font color and make sure the characters remain easy to distinguish. Do not use color as the only signal for important information; add a label, symbol, or status value too.
- Color a whole range at once. Select all of the intended cells before opening the palette rather than applying the shade cell by cell. This is quicker and helps ensure the same fill is used throughout the range.
- Use themes when the workbook has a design. Theme Colors are useful for matching headings, charts, and other workbook elements. A custom color is more suitable when you must match a specific supplied color value.
- Know when to use conditional formatting. A normal fill stays as you set it until you change it. If cells should change color automatically when their values meet a condition, use Home > Conditional Formatting instead. A conditional-formatting rule can affect the color displayed, so review or adjust that rule if a manual fill does not appear as expected.
- Use the keyboard on Windows when it helps. Press Alt+H, H to open the Fill Color palette, then use the arrow keys to move through available colors and press Enter to select one. On Mac, ribbon shortcuts depend on the keyboard and Excel version; using the Home tab’s Fill Color control is the dependable option.
Troubleshooting
- The color does not appear: Confirm that the intended cells are selected and that you chose a color rather than No Fill. If the cells belong to a formatted table or the sheet uses conditional formatting, check whether a table style or rule is affecting the displayed appearance. Open Home > Conditional Formatting > Manage Rules to inspect applicable rules; the options shown can depend on the selected range and Excel version.
- The color appears in the wrong cells: Press Ctrl+Z on Windows or Command+Z on Mac as soon as possible. Then select the correct range carefully and apply the fill again. If undo is no longer available, select the unintended cells and choose Fill Color > No Fill, taking care not to remove fills that belong there.
- The text is difficult to see: Open the Font Color palette and choose a contrasting text color, or replace the fill with a lighter shade. Check the actual cell contents at normal zoom; a bright fill may look readable when zoomed in but be difficult to read in a full worksheet or printout.
- The Fill Color control is unavailable: The worksheet may be protected or the workbook may be in a restricted editing state. Check Review > Unprotect Sheet if you have permission and the password, or ask the workbook owner to enable formatting. If the file is read-only, save an editable copy only if you are allowed to do so.
- The shade is not in the palette: Choose More Colors and enter the custom value if your version offers that option. If you cannot enter a hexadecimal value, use its RGB equivalent or pick the closest available shade. Keep a note of the chosen values if the same exact color needs to be reused in other workbooks.
- The color changes when a value changes: A conditional-formatting rule is likely setting the displayed fill. Open Home > Conditional Formatting > Manage Rules, select the relevant rule, and edit or remove it only if appropriate. A manual fill is not a reliable substitute for reviewing a rule that is designed to update automatically.
Frequently Asked Questions
Can I color multiple Excel cells at once?
Yes. Select a contiguous range by dragging across it or using Shift with the first and last cell. For separate cells, hold Ctrl on Windows or Command on Mac while selecting them, then choose a fill color.
How do I color a cell without changing its contents?
Apply a fill using Home > Fill Color. This changes the cell’s appearance, not its text, number, date, or formula. Choosing No Fill later removes the background without deleting the contents.
Can I enter an exact color in Excel?
Often, yes. Open the Fill Color palette and choose More Colors. The available ways to specify a custom color vary by platform and version; look for RGB fields or a hexadecimal field in the dialog.
How do I color cells automatically based on their values?
Use Home > Conditional Formatting and choose a rule that matches your needs, such as highlighting cells above a value. Set the formatting for the rule there. A normal Fill Color choice is manual and will not update automatically when a value changes.
Will cell fill color print?
Usually, cell fills are included when you print a worksheet, but printer settings and print output can affect how they look. Check File > Print and use the preview before printing, particularly if the color is important for understanding the sheet.
What is the difference between No Fill and a white fill?
No Fill removes the cell’s background formatting so the underlying sheet or table appearance shows through. A white fill is an actual background color and may cover a table style or other background appearance. Use No Fill when you want to clear a fill rather than paint the cell white.
Related
- Negative Numbers in Brackets in Excel: How to Format
- Excel Drop-Down List With Color: Setup and Formatting
- How to Lock an Excel Row at the Top While Scrolling
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Named Range: How to Create OneTo create a named range in Excel, select the cells, type a clear name in the Name Box…
- How to Create an Email Distribution List in OutlookTo create a reusable email list in Outlook, open People and create a contact group or contact list,…
- How to Insert a Page Break in Excel for Better PrintingTo insert a manual page break in Excel for Microsoft 365 on Windows, select the row below or…
- How to Clear the Outlook GAL CacheTo refresh the Global Address List (GAL) cache in classic Outlook for Microsoft 365 on Windows, select Send/Receive…
- Google Sheets Scheduling: Create a Shared ScheduleTo use Google Sheets for scheduling, create a spreadsheet with one row per shift, appointment, or task; add…
- Excel AutoSave: How to Turn It Off and Keep Changes SafeTo turn off AutoSave for the workbook you have open in Excel for Microsoft 365 on Windows, switch…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.