Flaging up an alert
 

I have created a simple form for taking bookings I need to be
alerted should i dupicate date information IE there is already a
booking on this date. if a formula is needed could the same formula
be used for times as well

IE already booked at this time, or already booked at his date


--
kevatt
------------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...o&userid=30245
View this thread: http://www.excelforum.com/showthread...hreadid=504167

Flaging up an alert
 

Possibly look at the techniques outlined at Chip Pearson's site:

http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy


"kevatt" wrote in
message ...

I have created a simple form for taking bookings I need to be
alerted should i dupicate date information IE there is already a
booking on this date. if a formula is needed could the same formula
be used for times as well

IE already booked at this time, or already booked at his date


--
kevatt
------------------------------------------------------------------------
kevatt's Profile:
http://www.excelforum.com/member.php...o&userid=30245
View this thread: http://www.excelforum.com/showthread...hreadid=504167

Flaging up an alert
 

Or try using Conditional Formatting:

If oyur dates were entered in column A, then select column A and open
Conditional Formatting from the Format menu.

with 'Formula Is' in the Conditional Format box, enter:
"=IF(COUNTIF(A:A,A1)1,TRUE,FALSE)" and change the format to yellow, or
whatever.

Now whenever you enter a date, it will change colour if it already
exists.