Yes. In Excel for the web, select the cells you want to format, then choose Home > Conditional Formatting and create a rule. The rule changes a cell’s appearance—such as its fill color, font, data bar, or icon—when its value meets a condition; it does not change the underlying value.
The browser version can handle many everyday conditional-formatting tasks, including common built-in rules and formula-based rules. Some options or rules created in desktop Excel may not be available to edit in the browser, so the exact commands you see can depend on the rule and the current Excel interface.
What conditional formatting does
Conditional formatting makes patterns in a worksheet easier to spot. Rather than manually coloring a cell, you define a condition and let Excel apply a format when that condition is true. If the value changes and no longer meets the condition, Excel removes the formatting automatically. This is useful for tracking deadlines, finding unusually high or low numbers, and identifying duplicate entries.
For example, a sales list could use a color scale to show lower sales in one color and higher sales in another. A project tracker might highlight overdue work, while a stock sheet could mark quantities below a reorder point. The worksheet still contains the same dates, numbers, and text; the formatting is a visual cue layered over the cells.
Conditional formatting is different from sorting or filtering. It does not rearrange rows or hide records, and a red fill does not mean Excel has changed a number or classified it as an error. It simply applies the format you chose when a rule evaluates as true.
Create a built-in rule in the browser
For a first rule, use a small, clearly defined range so it is easy to check the result. In Excel for the web, open the workbook in a browser, select the cells, and use the Home tab. The available rule categories include options for highlighting cells, finding top or bottom values, and applying data bars, color scales, or icon sets.
- Select the cells to which the rule should apply. For a column of values, select the values rather than the heading.
- Choose Home > Conditional Formatting. Select an appropriate category, such as Highlight Cells Rules, Data Bars, Color Scales, or Icon Sets.
- Choose the condition or visual style, then enter any required comparison value. For example, a “greater than” rule needs a number to compare against.
- Choose the format offered by the dialog, such as a fill color, and confirm the rule.
- Check several cells, including values just above and below the threshold, to make sure the rule is behaving as intended.
A simple example is highlighting values below 10 in a stock-count column. Select the data cells, choose Home > Conditional Formatting > Highlight Cells Rules, and select the less-than condition. Enter 10 and choose a format. A count of 7 meets the condition; a count of 12 does not. If the list later changes, Excel recalculates the rule for the affected cells.
When choosing the range, consider whether new rows will be added. A rule applied only to the current records may not cover data entered beneath them later. You can select a suitably larger range, or format the data as an Excel table so that added table rows can inherit formatting behavior. Confirm the result after adding records rather than assuming every workbook layout expands identically.
Use a formula for a custom condition
A formula-based rule is useful when a built-in condition cannot express the relationship you need—for example, when a cell should be highlighted based on another column. Select the target range, choose Home > Conditional Formatting > New Rule, and look for the formula rule option. Depending on the interface, it may be described as using a formula to determine which cells to format. Enter a formula that evaluates to TRUE or FALSE, then choose the format.
Suppose A2:A20 contains task names, B2:B20 contains due dates, and C2:C20 contains status text. To highlight an entire task row across A2:C20 only when its status is Overdue and its due date has passed, select A2:C20 and use this rule formula: =AND($C2="Overdue",$B2<TODAY()). The dollar signs keep the status and due-date columns fixed as Excel evaluates each row, while the row number changes. If row 2 contains a past due date and the status Overdue, cells A2:C2 are highlighted; a row marked Complete is not.
That example uses TODAY(), so the condition can change as the calendar date changes. It is appropriate for a live overdue list, but it is not a fixed historical test. If the workbook needs to preserve the status as it was on a particular date, use a fixed date or a recorded status instead of relying on a moving current-date condition.
Formula references are interpreted relative to the top-left cell of the selected “Applies to” range. If the range begins at A2, write the formula as if it were being checked for row 2. A reference such as $C2 locks the column but allows the row to adjust. Locking both the column and row, as in $C$2, makes every cell refer to the same fixed cell. Incorrect anchoring is a frequent reason that a rule appears to highlight the wrong rows.
Choose the right rule type
Built-in rules are usually faster to create and easier for colleagues to understand. A numeric threshold, duplicate-value check, or color scale is a good fit when the condition can be described directly through the dialog. Formula rules give you more control, but they require careful references and testing.
- Highlight Cells Rules: Use for comparisons such as greater than, less than, equal to, text that contains, dates in a period, or duplicate values, when those options are available in the dialog.
- Top/Bottom Rules: Use to call attention to a specified number or percentage of high or low values, or to values above or below an average.
- Data Bars: Use for a quick visual comparison of magnitudes within a range. A longer bar represents a larger value.
- Color Scales: Use when the relative distribution matters, such as showing low, middle, and high values with a gradient.
- Icon Sets: Use for compact categories or status signals. Check the thresholds so that each icon means what readers expect it to mean.
- Formula rules: Use when the condition depends on another cell, a combination of tests, or a row-specific relationship.
More visual indicators are not always more informative. A color scale can be misleading if readers assume its colors represent fixed business targets, because the scale is generally based on values in its selected range. For a clear pass/fail threshold, a direct rule may be easier to interpret than a gradient.
Edit rules and understand their scope
If a format appears unexpectedly, check which cells the rule covers before changing the formula. Choose Home > Conditional Formatting and open Manage Rules if that command is available in your browser interface. The rule manager lets you inspect rules and their ranges; select the relevant rule to edit it. A workbook may contain several rules affecting the same cells, so look at all rules for the selected area rather than assuming the first visible rule is the only one.
To remove formatting rules, select the affected cells and use Home > Conditional Formatting > Clear Rules, choosing the option for the selected cells if offered. Be cautious with a command that clears rules from an entire worksheet: it can remove formatting beyond the area you meant to fix. Clearing conditional-formatting rules does not delete cell values, but it does remove the visual conditions.
Rule scope matters when copying or extending data. Copying cells can also copy their conditional formatting, potentially creating overlapping rules or applying a rule to a larger range than intended. After pasting, inspect the highlighted area and the rule’s range. When a rule uses formulas, confirm that relative references still point to the intended row and column.
Excel for the web compared with desktop Excel
Excel for the web is useful for creating and reviewing many standard rules without installing the desktop app. It is particularly convenient for a workbook stored in OneDrive or SharePoint and edited by multiple people. Changes made in the browser are saved to the workbook, and collaborators can see the resulting formatting when they open it.
Desktop Excel for Microsoft 365 on Windows offers a fuller environment for working with complex workbooks. Some rule types, advanced settings, or rules created in desktop Excel may not have all their editing controls in the browser. If a rule is visible but its settings cannot be changed online, open the workbook in the desktop app and use Home > Conditional Formatting > Manage Rules. On Mac, the Home tab also contains Conditional Formatting, although dialogs and menu presentation can differ from Windows.
For a browser workflow, use the web version when the rule is straightforward and the available dialog exposes the needed settings. Move to desktop Excel when the browser cannot create or edit a particular rule, when the manager does not show a required option, or when you need to carefully diagnose interactions among many rules. Opening a workbook in desktop Excel does not make the rule itself different, but the desktop interface may expose controls that the browser does not.
Common problems and practical checks
When a rule does not work as expected, test the condition separately from its appearance. Check that the selected range contains the intended cells, that the threshold is entered as a number or date rather than unintended text, and that the formula refers to the correct columns. Dates that look alike can be stored differently, and a text value such as “10” may not behave like the number 10 in a numeric comparison.
- The wrong rows are highlighted: Check the top-left cell of the range and the formula’s dollar signs. A fixed row reference can make every row test the same record.
- No cells change: Verify that at least one cell actually meets the condition. For formulas, check that the result is TRUE for a sample row and that text matches, including spaces.
- Unexpected cells change: Inspect the rule’s “Applies to” range and look for overlapping rules or formatting copied from another area.
- The format is hard to read: Choose a restrained fill and readable font color. A strong fill can obscure existing text or make a chart-like scale difficult to interpret.
- A rule is unavailable to edit: Try the workbook in desktop Excel. The web interface may not expose every control used by a rule made in another version.
Also remember that conditional formatting is not a data-validation or security feature. It can draw attention to an invalid entry, but it does not prevent someone from entering that value. Use data validation when you need to restrict the values users can enter, and use appropriate workbook permissions when access needs to be controlled.
Frequently Asked Questions
Can I use conditional formatting in Excel for free online?
Excel for the web is available through a Microsoft account, but access and features can depend on the account and organization. Many common conditional-formatting tasks are available in the browser. If a particular rule or editing control is missing, try desktop Excel or check the options provided by your account.
Can Excel for the web use formula-based conditional formatting?
Yes, the browser version supports formula-based rules in its conditional-formatting interface. Select the range and look under New Rule for the formula option. If the workbook’s existing rule cannot be edited online, open it in desktop Excel.
Does conditional formatting change the cell value?
No. It changes how a cell is displayed, not the stored value. A red cell remains the same number or text, so use a formula, filter, or data-validation rule if you need to calculate, find, or restrict entries.
Will conditional formatting remain when I download a workbook?
Conditional formatting is part of an Excel workbook and is generally retained when you download it as an Excel file. A CSV file does not preserve Excel formatting rules; it stores plain tabular data. Reopen the downloaded workbook to confirm that an important rule has carried over as expected.
Why can’t I edit a conditional-formatting rule in my browser?
The web app does not expose every setting for every rule. A rule created in desktop Excel, or a more complex rule, may be viewable without all its editing controls. Open the file in desktop Excel and inspect Home > Conditional Formatting > Manage Rules.
Related
- Excel Power Query and Business Intelligence Explained
- Best Way to Compare Data in Two Excel Sheets: 5 Methods
- Basic Conditional Formatting in Excel: A Practical Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- One Page Landscape in Word: How to Change One PageTo make just one page landscape in Microsoft Word, isolate it in its own section with a section…
- How to Print Gridlines in ExcelTo print gridlines in Excel for Microsoft 365 on Windows, open the worksheet, go to Page Layout, and…
- How to Add Footnotes in Microsoft Word on Windows and MacTo add a footnote in Microsoft Word, click where its reference number should appear, then select References >…
- XLOOKUP in Google Sheets: How It Works and When to Use ItYes. Google Sheets supports XLOOKUP, so you can search one range for a value and return the corresponding…
- How to Schedule Send Email in Outlook: A Step-by-Step GuideTo schedule an email in Outlook, write your message, open the menu beside Send, choose Schedule send, then…
- Excel: Expand Print Area to Fit a PageTo make an Excel printout fit a page, select the cells you want, choose Page Layout > Print…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.