Conditional Formatting

[major2448]

If I have two columns with date values, how do I create a rule to have A1 highlighted if its value is not equal to B1?

[Mazzaropi]

major2448, Good morning.

Try to use:

=A1<>B1

Put it at Conditional Format in a formula.
Choose your desired color.

Apply it to a column A.

Is it what you want?
I hope it helps.

[Tony Valko]

Try this...

Select cell A1

Conditional Formatting

Select the "Use a formula to determine which cells to format" option

Use this formula:

=(COUNT(A1:B1)=2)*(A1<>B1)

[major2448]

How do highlight a cell in one column if its value is not equal to its corresponding cell in another column?

[Mazzaropi]

I answered you at my previous post.

[Mazzaropi]

major2448, Good afternoon.

Take a look at this example I did for you:
25-07-2014_ExcelForum_Conditional_Format_Example-OK.xlsx

Is it what you want?
I hope it helps.