Need help for Conditional Formatting formula

ybr_15

Board Regular
Joined
May 24, 2016
Messages
204
Office Version
  1. 2019
  2. 2013
Platform
  1. Windows
Hi, I have some timestamp like this:
----------Origin--------------------Modified----------
TimestampTimestamp
8:32:05 AM8:32:05 AM
8:32:28 AM8:32:28 AM
8:32:54 AM8:31:14 AM
8:33:12 AM8:33:12 AM
8:33:37 AM8:33:37 AM
8:33:59 AM8:32:59 AM
8:34:22 AM8:34:22 AM
8:34:47 AM8: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..
 
ybr_15,
Please confirm that you did not select your first row of data.

Also please confirm that you entered the following conditional formatting formula:
Code:
=A4+LessThan+A3
And that you replaced "+LessThan+" with the actual less than symbol (<).
 
Upvote 0

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Yes, I follow your instruction with that symbol (less than). For example, are you successful to get highlight data like in the Modified column with your formula? Thanks
 
Upvote 0
Yes.
Column A looks like this:

A
1Modified
2Timestamp
38:32:05 AM
48:32:28 AM
58:31:14 AM
68:33:12 AM
78:33:37 AM
88:32:49 AM
98:34:22 AM
108:33:47 AM

<tbody>
</tbody>

Conditional Formatting:
Formula:
Code:
=A4+LessThan+A3

Format:
Text Color = Red

Applies to:
Code:
=$A$4:$A$10

What is the result you are seeing with the data from the modified column?
 
Last edited:
Upvote 0
Hi, DushiPunda

I am sorry, my bad. You right, the formula works properly. Thanks a lot for your efford and help :)
 
Upvote 0
show us data in A1 A2 A3 A4 A5 and tell us in words what you want

if it is 09:00 09:02 09:03 09:02 09:05
then do you want the 4th time highlighted ?
 
Upvote 0

Forum statistics

Threads
1,213,583
Messages
6,114,482
Members
448,575
Latest member
hycrow

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top