Excel Forum



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
6Format
7Click OK





Got a Question? Ask it Here in the Forum.