Excel Guides

Understanding Color and Conditional Formatting Codes in Excel

Excel uses a system of color coding and conditional formatting to help users quickly identify important data. Here is a breakdown of what the different colors and codes mean:

Color Coding

Excel uses color coding to indicate the following:

  • Negative numbers: Negative numbers are displayed in red by default.
  • Text: Text is displayed in black by default.
  • Formulas: Formulas are displayed in green by default.
  • Dates and times: Dates and times are displayed in blue by default.
  • Hyperlinks: Hyperlinks are displayed in blue by default.

  • Number formats:
  1. General number
  2. Percentage
  3. Currency

  • Accounting number format (uses currency symbols)

  • Date format (uses day/month/year order)

Move beyond 


Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.