Conditional Formatting.

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional Formatting.

FAQ

Thread Tools

Display Modes

Laurie B. Conditional Formatting. 04-03-2012, 06:28 AM

JBeaucaire You're right about copying... 04-03-2012, 08:11 AM

Laurie B. I am not sure what I am doing... 04-03-2012, 02:45 PM

JBeaucaire Maybe the primary formula... 04-03-2012, 03:11 PM

Laurie B. Thank you for your efforts. ... 04-04-2012, 09:50 AM

caholmes Hi Laurie B, these can be... 04-06-2012, 06:54 PM

macropod An alternative approach,... 04-09-2012, 05:01 PM

04-03-2012, 08:11 AM

JBeaucaire JBeaucaire is offline

Windows XP Conditional Formatting.

Office 2003

Advanced Beginner

Join Date: Dec 2011

Posts: 51

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting	zanat0s	Excel	4	01-20-2012 03:30 AM
Conditional formatting with AND, OR	Lucky	Excel	2	10-03-2011 11:41 PM
Conditional Formatting	namedujour	Excel	3	08-25-2011 01:46 PM
help with conditional formatting	Snvlsfoal	Excel	3	07-03-2011 11:55 PM
* Conditional Formatting MS 2010	djreyrey	Excel	3	06-03-2011 01:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:00 PM.