Thread: [Solved] Conditional Formatting.
View Single Post
 
Old 04-03-2012, 08:11 AM
JBeaucaire JBeaucaire is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

You're right about copying everything, there HAS to be something to compare to to accomplish this through conditional formatting.

So, let's say everything in column A is duplicated in column AA. As you make edits in column A the values would no longer match and you could highlight the cells via that fact.

So, highlight column A and use this CF setting:

Condition1: Formula Is: =A1<>AA1
Format... Pattern: Yellow
Reply With Quote