Need to use conditional formating to highlight a cell

[Paul Ak]

I need a formula in conditional formatting in excel 2010 to change color when the date time group of one cell "10aug20142105" is subtracted from and other cell "11aug20140150". Is this possible?

[ChemistB]

Can you give some examples with real cell references? (Ideally, attach worksheet showing what you want - Go Advanced>Manage Attachments)

So if time one is in A1 and time 2 is in B1, you want to change the color of the cell if C1 = B1-A1? Are there other options for C1?

[Paul Ak]

excel example.xlsx

The attach is generally what I am looking for. The Date Time group is in text. Again, any help is appreciated.

Paul

[ChemistB]

Here is the formula to subtract the two

=DATEVALUE(LEFT(E5,LEN(E5)-5))+(MID(E5,LEN(E5)-3,2)&":"&RIGHT(E5,2))-(DATEVALUE(LEFT(C5,LEN(C5)-5))+(MID(C5,LEN(C5)-3,2)&":"&RIGHT(C5,2)))
values less than 1 are less than 1 full day (24 hours)

Here is the conditional Formatting formula to turn things blue.
=DATEVALUE(LEFT($E5,LEN($E5)-5))-(DATEVALUE(LEFT($C5,LEN($C5)-5)))>=1