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.
- General number
- Percentage
- Currency
- Accounting number format (uses currency symbols)
- Date format (uses day/month/year order)