Create conditional formatting between 2 date time

[Halidat]

Hello everyone,

I am importing data from outside source, and would like to highlight in red whenever A2 is not equal to B2.

I tried with highlight using conditionnal formatting whenever A2 wasn't equal to the cell B2, but everything became red.

[TMS]

Just select row 2 down and use the formula:

Please Login or Register  to view this content.

[Pete_UK]

Note that both sets of data have seconds associated with them, although your formatting does not show these. Consequently, you may get cells highlighted which look to be the same as the adjacent cell.

Pete

[TMS]

Mmm, Pete's right. I hadn't checked the workbook.

This might be closer to what you need:

Please Login or Register  to view this content.

[Halidat]

Hello,

Thank you for your reply!

It almost worked, but it highlight the ones that are equal, and I am looking for the ones not equal

[Pete_UK]

Change the equals sign, = , to not equal to, i.e. < > in the formula.

Hope this helps.

Pete

[Halidat]

It works thank you!!!

[TMS]

You're welcome.

And thanks Pete


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.