Conditional Formatting - using Time (or NOW())

**Apache_sim** · 07-04-2013, 09:51 AM

Is it possible prevent depending on current time, using conditional formatting or is this VBA?

I would like to prevent a user from editing a cell (or small group cells) if the time NOW() is less than 24 hours of the time displayed in the reference cell (top cell of the column).

For instance 7 columns with a start time in the top cell, every two hours; 8:00, 10:00, 12:00, 14:00, etc. A user would be allowed to enter data if more than 24 hours but the cells become frozen or password protected form change if lesss than 24 hours.

Regards

**dilipandey** · 07-04-2013, 09:56 AM

Hi Apache_sim,

You can have a now() function in a cell and then you can have time difference in another cells... now you can lock required cells till the time difference is not equal to or greater than 24... this is just a simple logic statement which I have written.. doing practically may involve little bit of modifications

Regards,
DILIPandey
<click on below * if this helps>

**Apache_sim** · 07-04-2013, 10:03 AM

hi dilipandey,
Thanks for the reply, I think I can write the formulae to copmare the time diffrence, what I can't see is how to prevent the cells from being editied inside of the 24 hours.

**Apache_sim** · 07-08-2013, 08:37 AM

I can't see what Dilipandy was suggesting .

The attached doc represents a daily schedule.

I have used condidtional formating to fill for each session and session type.

The start time for each session is fixed i.e. G4 = 08:00.
I would like to be able to compare the current time with the start time in G4 and if less than 24 hours remain to that start time, then prevent further edits by protecting the cells.

I have been looking at condidtional formating but can't see a suitable option.

Regards

**dilipandey** · 07-08-2013, 08:58 AM

my bad that I am not clear... let's see what others has to say. thanks.

Regards,
DILIPandey
<click on below * if this helps>

**Apache_sim** · 07-09-2013, 10:27 AM

I think I have worked most of it out....
DATE includes the TIME as 00:00:00 by adding the start TIME of the session and checking to see if it is < NOW() seams to work....