Conditional Formatting in Excel 2013 1

[beadedbytes]

I'm trying to figure out how to use Excel 2013 conditional formatting to compare data.

For example, if A1<>C1, then format C1 as yellow fill. Likewise, if B1<>D1, then format D1 as yellow fill. And so on and so on for rows 2, 3, etc.

What is the best way to execute conditional formatting for this example? Or, is there another method that would make more sense in Excel 2013?

Thanks in advance for feedback!

[white]na[/white]		Col A		Col B		Col C		Col D
Row1		Aaron		Mitchell	Aaron		[highlight]Melville[/highlight]
Row2		Bobby		Smythe		Bobby		Smythe
Row3		Richard		Worthington	[highlight]Raymond[/highlight]		Worthington
Row4		Eric		Taylor		[highlight]Edmund[/highlight]		[highlight]Tyler[/highlight]
Row5		Michael		Goldwyn		Michael		Goldwyn

 

[SkipVought]

Hi,

Select the data in columns C & D

Open the CF Wizard

Select the Enter Formula option

Enter this formula...
[tt]
=A1<>C1
[/tt]

Set your format and OK

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[beadedbytes]

Thank you, Skip.

Glad to know you're still serving his community with such valuable solutions.

Wishing you much good karma!

 

[beadedbytes]

One last question.

Once the conditional formatting has been accomplished, is there a way to keep the formatting (cell highlights), but remove the formula behind it?

I've tried Copy >> Paste Special >> Value (or something called 'Merged Conditional Format') without success.

If not, will make the file ready only before giving the document to others.

 

[SkipVought]

What is the reason?

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[beadedbytes]

I don't want recipient to inadvertently change a cell (or cells), thereby changing the comparison (e.g. changing D1 from Melville to Mitchell, for some reason).

 

[SkipVought]

Why not protect the sheet so that nothing can change?

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[beadedbytes]

i did. Thanks, Skip!