Excel Conditional Formatting Not Working: Complete Fix Guide

Problem Scenario

You've set up conditional formatting rules but cells aren't changing color or format as expected. Rules seem to be ignored.

Solution Steps

1. Check rule order and priority in Conditional Formatting Rules Manager
2. Verify rule formula references correct cells
3. Clear conflicting rules on same range
4. Check if cells are formatted as text instead of numbers
5. Use Formula type instead of Cell Value for complex rules

Code Snippet

Home > Conditional Formatting > Manage Rules > Reorder or Edit rules