Hi,

What would be the conditional Formating in the column B & C

A B C
Time In | Time Out | Time In
9:30AM | 8:25 PM | 9:31 AM


Members working late after 20:30hrs will be given the permission to
come to work the next day by 10:30hrs.

So in Column B i have placed only one condition that if the employee
works after 20:30hrs make the font bold otherwise regular fonts.

In Column C what would be the conditional formating.

Our company policy is:

If worked till 20:29hrs then the employee is allowed to resume his
work by 9:30hrs next day, if after 9:30hrs it should be Red in color.

if worked till 20:30hrs then the employee is allowed to resume his
work by 10:30hrs next day. if after 10:30hrs it should be red in
color.

How to put the conditional formating in the Column "C"

Awaiting for your response.

Thanks

Akash Maheshwari