Custom formulas referencing other sheets, Google-specific functions (like GOOGLEFINANCE or IMPORTRANGE), and color scales based on percentiles or min/max will break or convert to static values. Rules using standard cell references, text contains, or date conditions on the same sheet typically survive the download intact.
Why Google Sheets conditional formatting breaks on desktop download
If you need to prepare your file for export, start by auditing every conditional formatting rule against this checklist, much like you would download Google docs with comments as PDF to preserve collaborative feedback before leaving the Google ecosystem.
Custom formulas that reference other sheets
When a conditional formatting rule uses a custom formula like =Sheet2!A1>5, the cross-sheet reference may not resolve correctly in Excel. The formatting may disappear entirely. To spot these before you download Google sheets to desktop, open the conditional formatting panel and look for any rule where the "Apply to range" or "Custom formula is" field contains an exclamation mark or a sheet name in single quotes. Replace those cross-sheet references with INDIRECT functions, or copy the source data onto the same sheet before export.
Google-specific functions inside rules
Functions such as GOOGLEFINANCE and IMPORTRANGE have no equivalent in Excel. If you use any of these inside a custom formula within a conditional formatting rule, the entire rule fails silently when the workbook opens in .xlsx format. The rule may fail silently when the workbook opens in .xlsx format. To avoid losing formatting, replace each Google-specific call with static data before you download Google doc as an Excel file. For example, replace =GOOGLEFINANCE("GOOG","price")>500 with the actual price typed into a cell, then reference that cell in the rule.
Color scales and icon sets tied to dynamic defaults
Google Sheets color scales and icon sets can use "Percentile," "Min," or "Max" for their midpoint calculations when you create a rule. Excel may not support dynamic percentile or min/max midpoints in conditional formatting. When you download the sheet as an .xlsx file, the dynamic midpoints may convert to static numeric values based on the data at the moment of export. If your data updates later, the colors and icons will not recalculate. To preserve dynamic behavior, manually set each midpoint to "Percent" (e.g., 50% for the middle) instead of "Percentile," or use a formula-based rule that references a helper column. Check the "Edit rule" panel in Google Sheets for any gradient or icon set that shows "Percentile" or "Min/Max" in the dropdown, those are the ones that will freeze.
The false assumption that all rules survive
A common mistake is assuming a clean-looking .xlsx preview means the logic migrated correctly, when in fact broken rules are stripped without warning. Excel may not highlight missing rules or show error icons for removed conditional formatting. You must manually compare the "Conditional format rules" pane in Google Sheets against the conditional formatting rules manager in Excel after download. For each rule, verify that the formula, range, and style match exactly. If you used any custom formula referencing another sheet or a Google-specific function, expect it to be gone. Even rules that appear to work may have shifted ranges if your sheet contains merged cells or hidden rows. Always run a full audit before you distribute the file, and remember that the export process is one-way, you cannot recover the original logic from the .xlsx file.
The only audit method that catches silent failures
A manual side-by-side audit of the Google Sheets rules pane and the Excel rules manager can help confirm what survived export.
