Excel Forum
Similar Content
Make Complex Formulas for Conditional Formatting in Excel
Tutorial: How to make complex formulas for conditional formatting rules in Excel. This will serve as...
Multiple Conditional Formatting Rules for a Cell in Excel
Tutorial: Apply multiple Conditional Formatting rules to a cell or range in Excel. This allows you ...
Apply Conditional Formatting to Multiple Cells with a Single Formula
Tutorial: How to use a single formula to apply conditional formatting to multiple cells at once in E...

Excel Magic Trick 474: Conditional Format At Every Change In Value

See how to Conditional Format At Every Change In Value. Steps
1Highlight range A1:A2152
2Alt + O + D (opens) Conditional Formatting
3Click New Rule
4Click "Use Formula"
5Enter formula: A1not A2
7Click OK

Got a Question? Ask it Here in the Forum.