Need help for Conditional Formatting formula

[ybr_15]

Hi, I have some timestamp like this:

----------Origin----------		----------Modified----------
Timestamp		Timestamp
8:32:05 AM		8:32:05 AM
8:32:28 AM		8:32:28 AM
8:32:54 AM		8:31:14 AM
8:33:12 AM		8:33:12 AM
8:33:37 AM		8:33:37 AM
8:33:59 AM		8:32:59 AM
8:34:22 AM		8:34:22 AM
8:34:47 AM		8:33:47 AM

<tbody>
</tbody>

Let's say the table above is user1, user2, etc. attendance. In the Origin column, I have some timestamp (will be in sequence if all users are honest) based on when user click "Timestamp" button. In the Modified column is simulated the problem. If user is cheating (change windows time in pc), I want mark his/her timestamp with different font color. Please help me how to so that! Thank you..

 

[oldbrewer]

in C3 conditional formatting

=c3<a3

 

[oldbrewer]

=c3 < a3 darned forum eats < and > sometimes lol

 

[ybr_15]

Hi, oldbrewer

Please let me know If my explanation is not clear. Let's say the first timestamp in A3. The timestamp just be put in column A. Btw, Can you help me? Thanks..

 

[ybr_15]

Does anyone here can help me?..
FYI: The Modified column just "simulate"problem from the Origin column. So, if the Origin column has problem like in the Modified column (data not in sequence), how to solve that problem?.

Thanks..

 

[DushiPunda]

ybr_15,
Just to be clear, on your worksheet where this data is stored, there is only one column? In other words, you don't actually have an origin and a modified column?

I think I see what you are trying to do. Please give me a couple minutes to see what I can come up with.

ybr_15,
Assuming you do indeed only have one column, here's what you need to do:1

1. Highlight/select the range of data but do not highlight the first row. Assuming your first timestamp is in A3 and your last timestamp is in A10, you need to highlight A2:A10.
2. Conditional Formatting > New Rule > Use a formula to determine which cells to format
3. Enter the following formula (remove the spaces before and after the less than symbol):

=A4<a3[ code]
*LessThan*A3

--Dammit the removing of the less than and greater than symbols is annoying. Replace *LessThan* with the less than symbol.
4. Choose formatting to suit your needs.</a3[>

 

[ybr_15]

Hi, DushiPunda

Yes, you are right. The Origin is where the first timestamp will be stored (let's say cell A3). So, the Modified is not actually exist (just for simulate problem)

 

[DushiPunda]

And the time limit to edit posts is also annoying. Formula:

=A4+LessThan+A3

Replace +LessThan+ with the less than symble.

ybr_15,
Please see the edit to my previous post, and also refer to the text above in this post.

 

[ybr_15]

Hi, DushiPunda

Thanks for your response & help, but your suggestion doesn't work (got wrong highlight).

=A4<a3

</a3

 

[ybr_15]

Edit: =A4+lessthan+A3<a3< html=""></a3<>