To colour cells in Excel, select them and choose Home > Fill Color to apply a fill manually. To make colour change when cell values change, use Home > Conditional Formatting and create a rule.
Manual cell fills: the quickest method
A manual fill is a fixed background colour: it stays in place until someone changes or clears it. In Excel for Microsoft 365 on Windows, select one or more cells, open the Home tab, and use the arrow beside the paint-bucket-shaped Fill Color button in the Font group. Choose a theme colour or a standard colour. Clicking the main part of the button applies its current colour immediately; the arrow opens the palette so you can choose another.
You can colour a single cell, a rectangular range, or multiple non-adjacent cells. To select a range, drag across it or click the first cell, hold Shift, and click the last. To select non-adjacent cells on Windows, hold Ctrl while clicking each cell or range. On a Mac, use Command instead of Ctrl for non-adjacent selections. Then choose a fill once to apply it to all selected cells.
For a custom shade, open the Fill Color palette and choose More Colors, where available, to specify a colour. Theme colours are useful when you want workbook colours to stay consistent: changing the workbook theme can update theme-based formatting. Standard or custom colours give more direct control, but they may not follow a later theme change. To remove a manual background, use the Fill Color palette and choose No Fill.
If a cell contains text, a number, or a formula, filling it changes only its appearance, not its contents. For example, colouring a sales total yellow does not alter the total or its value. Font Color is a separate control: use it to change the text colour rather than the cell background.
Use conditional formatting for changing data
Conditional formatting applies a format when a condition is true. Unlike a manual fill, it can respond when a value changes, which makes it useful for deadlines, targets, exceptions, and trends. Select the cells to evaluate, then open Home > Conditional Formatting. Excel offers built-in options such as Highlight Cells Rules, Top/Bottom Rules, Data Bars, Color Scales, and Icon Sets.
For example, to mark values greater than 100 in a selected range, choose Home > Conditional Formatting > Highlight Cells Rules > Greater Than, enter 100, choose a format, and confirm. Excel evaluates each cell in the selected range and formats cells that meet the condition. The chosen colour is part of the rule, not a replacement for the stored value.
For more control, choose Home > Conditional Formatting > New Rule. Depending on the rule type, you can base formatting on cell values, a ranking, or a formula. To change or remove existing rules, use Home > Conditional Formatting > Manage Rules. The dialog lets you inspect rule conditions, formatting, and the range each rule applies to. If more than one rule could apply to a cell, rule order and the option to stop processing further rules can affect the result.
Colour a whole row based on one cell
A common task is highlighting an entire record when a status cell contains a particular word. Suppose the table occupies A2:D100 and each status is in column C. Select A2:D100, choose Home > Conditional Formatting > New Rule, select Use a formula to determine which cells to format, and enter this formula:
With status values in C2:C100 and the full table in A2:D100, use =$C2="Overdue". It evaluates to TRUE for a row whose column C entry is Overdue, so the chosen fill applies across that row.
Choose Format, set a fill on the Fill tab, confirm the dialogs, and check that the rule applies to $A$2:$D$100. The dollar sign before C locks the status column as Excel evaluates across each row; the row number remains relative so the rule checks C2, then C3, and so on. If the formula instead locks both the column and row, Excel may test only C2 for every record. Check spelling and stray spaces in status values if a row does not highlight as expected.
Choosing a colour method and palette
Use a manual fill when the colour is a deliberate annotation that should not depend on data—for example, marking cells that need review during a meeting. Choose conditional formatting when the colour should represent a value or update as the workbook changes. For a range of numeric values, a colour scale can reveal relative highs and lows; for a simple pass/fail or status distinction, a single-colour rule is often easier to interpret.
- Manual fill: best for one-off emphasis, section headers, or user-applied labels.
- Conditional rule: best for recurring thresholds, overdue dates, target checks, and status-driven highlights.
- Colour scale: best for showing a gradient across a numeric range, such as low, middle, and high values.
- Data bars or icon sets: useful when you want a visual indicator alongside the underlying values.
Keep a workbook’s colour scheme restrained and consistent. If red means overdue in one section and complete in another, readers have to relearn the meaning. A short legend can clarify non-obvious conventions, especially in shared files.
Find, sort, copy, and clear coloured cells
Colour can help organize a sheet, but it does not automatically classify the underlying data. Excel can sort or filter by cell colour in supported tables and ranges. Open the filter arrow for a column and look for Filter by Color, or use the sort options to sort by cell colour. This can be handy for reviewing manually marked items, but it is safer to use a dedicated status column when colour carries important business meaning. A text label can be searched, counted, and checked more reliably than colour alone.
To reuse a manual fill, copy and paste the cell as usual, or use Home > Format Painter to copy its formatting to another range. Be aware that copying a cell with conditional formatting may copy or extend a rule, depending on the destination and paste method. If the result is unexpected, inspect the rules through Manage Rules rather than repeatedly applying another fill.
To clear all formatting from selected cells, use Home > Clear > Clear Formats. This removes formatting such as fills, font styling, and borders, while leaving cell contents intact. It also removes conditional formatting in the selected cells. If you only want to remove a manual fill, use No Fill instead; conditional formatting may still display a colour because its rule remains active.
Common colour and rule problems
If a cell looks coloured but the Fill Color palette indicates no fill, a conditional formatting rule may be supplying the visible colour. Check Manage Rules and inspect the rules that apply to that cell. Conversely, if you set a manual colour and it does not appear, a conditional formatting rule may be taking precedence. Editing or deleting the relevant rule is usually better than adding another manual fill on top.
Rules can also cover a different range from the one you expect. In Manage Rules, inspect the Applies to range and correct it if necessary. When using formula-based rules, check which cell was active when you created the rule and whether relative and absolute references match the selected range. A rule intended for rows 2 through 100 should generally start by evaluating the row-2 reference when its applies-to range begins at row 2.
Other frequent causes include a threshold that excludes the value you meant to highlight, text stored in a cell that looks like a number, misspelled status labels, and overlapping rules. For date rules, verify that the entries are actual Excel dates rather than text that only looks like a date. Also consider whether a filter or hidden rows are making it seem as though some cells were not formatted. Use a small test range first when building a complex rule, then extend it once the result is correct.
Make colour meaningful and accessible
Colour should reinforce information, not be its only carrier. Someone viewing a printout in grayscale, using a screen reader, or having difficulty distinguishing certain colours may not be able to interpret a red-versus-green distinction. Pair colour with a text status, symbol, or clear label—for example, “Overdue” as well as a red fill. Use strong contrast between text and background, and avoid using many similar shades to represent categories that matter.
Conditional formatting can support accessibility by making exceptions stand out consistently, but a dramatic colour scale may exaggerate minor differences or obscure the significance of a number. Include units, headings, and a brief explanation of the scale where needed. When sharing a workbook, check that the important message remains understandable without relying on colour alone.
Frequently Asked Questions
How do I colour a cell in Excel?
Select the cell, then choose Home > Fill Color and pick a colour from the palette. Use the arrow beside the paint-bucket button to choose a different shade.
How do I make Excel colour a cell automatically?
Select the relevant range and create a rule under Home > Conditional Formatting. Choose a built-in condition or create a formula-based rule, then set the format to use.
How do I colour an entire row when a cell contains a word?
Select the rows or table range, create a formula-based conditional formatting rule, and use a reference to the status column that keeps the column fixed while allowing the row to change. For a range beginning in row 2 with statuses in C, =$C2="Overdue" checks each row’s status.
Why does a cell keep its colour after I choose No Fill?
A conditional formatting rule may still be applying a fill. Review Home > Conditional Formatting > Manage Rules and edit or remove the applicable rule; No Fill clears a manual fill, not the rule itself.
How do I remove colour without deleting cell contents?
For a manual background, choose Home > Fill Color > No Fill. To remove all formatting from selected cells while preserving their values, choose Home > Clear > Clear Formats.
Can I sort or filter by cell colour?
Yes. Use a column’s filter menu and choose Filter by Color when available, or sort by cell colour. For important categories, keep a text or numeric field as well so the data remains clear and usable without colour.
Related
- How to Insert a Checkbox in Excel
- Capitalize Button in Excel: What Works and What Doesn’t
- Cannot Save As in Excel? Causes and Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Remove Duplicates: Steps and Safer OptionsTo remove duplicates in Excel for Microsoft 365 on Windows, select your data, then choose Data > Remove…
- How to Set Up Auto Forwarding in Microsoft OutlookTo automatically send incoming Outlook email to another address, open Settings > Mail > Forwarding in Outlook on…
- How to Insert a New Row in Excel on Windows and MacTo insert a new row in Excel for Microsoft 365 on Windows, select the row heading where you…
- How Excel Goal Seek Works: Steps, Examples, and LimitsExcel Goal Seek works backward from a formula result: you specify the result you want, and Excel adjusts…
- Excel Accounting Format: How It Works and When to Use It ProperlyExcel’s Accounting number format displays monetary values with currency symbols and decimal points aligned in a column; apply…
- Excel Text to Columns: How to Split DataTo change text to columns in Excel for Microsoft 365 on Windows, select the cells, then choose Data…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.