MS Excel - excel colors

1. Built-in Excel Theme Colors

Excel has a set of default theme colors:

How to apply theme colors:

1. Select cells → Home → Font → Fill Color or Font Color.

2. Choose from theme colors, standard colors, or More Colors.

2. Using Custom RGB or HEX Colors

Excel lets you define your own colors.

Steps:

1. Select cell(s) → Home → Fill Color → More Colors.

2. Go to the Custom tab.

3. Enter RGB values or convert HEX to RGB.

Example:

• HEX #1ABC9C → RGB(26, 188, 156) → Pastel Teal.

3. Conditional Formatting with Colors

Conditional formatting lets you automatically change colors based on rules.

Steps:

1. Select your data range.

2. Go to Home → Conditional Formatting → New Rule.

3. Choose:

   • Highlight Cells Rules → predefined (greater than, less than, etc.).

   • Color Scales → gradient heatmaps.

   • Icon Sets → arrows, symbols.

   • Custom Formula → full control.

Examples:

• Highlight negative numbers in red:
  Formula: =A1<0

• Highlight weekends in light blue:
  Formula: =WEEKDAY(A1,2)>5

• Color cells with today’s date in yellow:
  Formula: =A1=TODAY()

4. Color Scales for Heatmaps

Excel has 3-color and 2-color gradients:

Steps:
Home → Conditional Formatting → Color Scales → Choose style.

5. Transparent Colors in Excel

Excel doesn’t support full transparency for cell backgrounds, but you can:

• Use lighter RGB colors for a faded effect.

• Reduce transparency only for shapes and charts:
  Right-click shape → Format Shape → Fill → Transparency Slider.

6. Color Coding Tips

• For tables: Use light pastels for better readability.

• For dashboards: Use consistent theme colors.

• For negative vs positive values:

  • Positive = Green (#92D050)

  • Negative = Red (#FF0000)

• For highlighting key data: Use bold + dark contrasting colors.

7. Quick Excel Color Shortcuts