Flaging up an alert

[kevatt]

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

[Tom Ogilvy]

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

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

--
Regards,
Tom Ogilvy


"kevatt" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[JakeyC]

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.