Excel 2007 : Timed Appoinments and matching them

**felicianf** · 05-26-2011, 01:33 PM

I would like to create an excel worksheet with Today's appointments I have given to my clients.
It Should look like this
"
26.05.2011

09 00 Mr John
09 30 Ms Wilson
10 30 Mr Clement
12 00 Ms Gayani
13 00 LUNCH
14 00 (No appointments given yet)
15 00 Mr May"

Then once the time reaches 09 00 the corresponding line should indicate that it is the time for Mr John. This can either by blinking the respective line or some remark against the line.

Similarly when the time reaches 09 30 Ms Wilson's line should blink.

Is there any way to achieve this?
Thanks

**NBVC** · 05-26-2011, 02:38 PM

You can highlight the row....

If your data is in say A2:B8, then select this range and go to Data|Conditional Formatting... then select Formula Is from the drop down menu and enter formula:

=$A2=LOOKUP(2,1/($A$2:$A$8<=MOD(NOW(),1)),$A$2:$A$8)

Click Format and choose from tabs...

adjust ranges to suit.

This highlights the row within current time range...