Color and Contrast in Excel Workbooks

Color is commonly used in Excel to highlight data, indicate status, or group information. However, relying solely on color excludes colorblind users and makes content less accessible.

What This Means

When color conveys meaning in your spreadsheet, you must also provide another way to understand that information. Additionally, text must have sufficient contrast with its background to be readable.

Why It Matters

• 8% of men have some form of color blindness
• Color-coded data is invisible to those who can't distinguish colors
• Low contrast makes spreadsheets hard to read, especially on screens
• Good color practices improve usability for everyone

Common Violations

XLSX-05-001: Data Differentiation Relies Solely on Color {#XLSX-05-001}

What's Wrong: The spreadsheet uses color as the only way to distinguish between data categories, status, or meaning.

Impact: Serious - Colorblind users cannot interpret the data correctly.

Common Examples:

• Red/green cells for pass/fail without text
• Color-coded categories without labels
• Conditional formatting using only colors
• Highlighted cells without explanatory text

How to Identify:

• Print/view the spreadsheet in grayscale
• Ask: "Can I understand all the data without seeing colors?"
• Look for legends that only reference colors

How to Fix:

Add Text Indicators:

• Include status text: "Pass," "Fail," "Pending"
• Add category labels in cells or adjacent columns
• Use symbols: checkmarks, X marks, bullets

Use Patterns with Colors:

• Apply different patterns to fill colors
• Combine with bold or italic formatting
• Use borders for additional distinction

Create Clear Labels:

• Add a legend that describes color AND meaning
• Include the meaning directly in cells when possible
• Use conditional formatting with icon sets

Example Fix:

Before (color only):

After (color + text):

XLSX-05-002: Cell Text Has Insufficient Contrast {#XLSX-05-002}

What's Wrong: Text in cells doesn't have enough contrast with the cell's background color, making it difficult to read.

Impact: Serious - Low contrast text is hard for everyone to read, especially users with low vision.

WCAG Contrast Requirements:

• Normal text: 4.5:1 contrast ratio minimum
• Large text (18pt+): 3:1 contrast ratio minimum

Common Problems:

• Light gray text on white cells
• Yellow text on light backgrounds
• Light colored text on colored backgrounds
• Custom themes with poor contrast

How to Check:

1. Select cells with colored text or backgrounds
2. Note the text color (Home > Font Color)
3. Note the background color (Home > Fill Color)
4. Use a contrast checker tool to verify ratio

How to Fix:

1. Select cells with low contrast
2. Change either text color or fill color to increase contrast
3. Darker text on light backgrounds or light text on dark backgrounds

Safe Combinations:

• Black text (#000000) on white (#FFFFFF) - 21:1
• Dark gray (#333333) on white - 12.6:1
• White text on dark blue (#000066) - 15.3:1

Avoid:

• Light gray (#999999) on white - 2.85:1 (fails)
• Yellow (#FFFF00) on white - 1.07:1 (fails)
• Red (#FF0000) on dark red (#800000) - 2.91:1 (fails)

Accessible Conditional Formatting

Excel's conditional formatting is powerful but can create accessibility issues:

Using Icon Sets

1. Select your data range
2. Go to Home > Conditional Formatting > Icon Sets
3. Choose icons that differ in shape, not just color
4. Icons provide meaning beyond color alone

Data Bars with Text

• Data bars can be combined with numeric values
• Users see both the bar and the number
• Ensure the number is readable against the bar

Color Scales with Labels

• If using color scales, add a labeled column
• Include the actual values or categories
• Don't rely on the color gradient alone

Chart Colors

Charts often use color to distinguish data series:

Multiple Differentiation Methods:

• Use different line styles (solid, dashed, dotted)
• Add direct data labels to series
• Use patterns in addition to colors
• Include a legend with shapes, not just colors

High Contrast Series:

• Choose colors that differ in brightness
• Test with grayscale view
• Avoid red/green combinations

Testing Your Spreadsheet

Grayscale Test:

1. Go to View > Page Break Preview or print preview
2. Print to PDF with grayscale setting
3. Review if all information is still clear

Color Blindness Simulators:

• Use online tools to simulate different types of color blindness
• Check if your color choices remain distinguishable
• Pay special attention to red/green

Best Practices

Do:

• Use color plus text, symbols, or patterns
• Choose high-contrast color combinations
• Test with grayscale view
• Provide clear legends and labels
• Use icon sets in conditional formatting

Don't:

• Use color as the only differentiator
• Use light text on light backgrounds
• Rely solely on red/green for pass/fail
• Assume everyone sees colors the same way

Additional Resources

• Microsoft: Make your Excel documents accessible
• W3C WCAG 1.4.1 Use of Color
• W3C WCAG 1.4.3 Contrast (Minimum)
• WebAIM Contrast Checker