how can I get excel to fill using a start and finish time

's Computer Specifications

start finish 800 830 900 930 1000
830 1000 Look at start and finish time and show against the times above
and colour using the fill option.

's Computer Specifications

select your times and do Format=>Conditional Formatting.

put in two conditions for the cell is equal to the start time, next
condition equal to the finish time.

--
Regards,
Tom Ogilvy

"djjom" <(E-Mail Removed)> wrote in message
news:77FCFE57-5A10-4697-B955-(E-Mail Removed)...
>
> start finish 800 830 900 930 1000
> 830 1000 Look at start and finish time and show against the times above
> and colour using the fill option.
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate a projected finish time from start time	RichieB	Microsoft Access Forms	3	12th Apr 2007 12:47 PM
how to calculate time start & time finish in quarter hour	=?Utf-8?B?UGV0ZXIgV3U=?=	Microsoft Excel Misc	3	7th Jun 2006 12:58 AM
template or formula for start time -finish time -total hours ple	=?Utf-8?B?Y2M=?=	Microsoft Excel New Users	1	27th Mar 2006 06:06 PM
formula for start - finsh time -halfhour ifsum of start-finish>8	=?Utf-8?B?bm9jb21wdXRhd2l6eg==?=	Microsoft Excel New Users	1	11th Oct 2004 07:31 PM
start and finish time	don	Microsoft Outlook Calendar	0	10th Feb 2004 06:29 PM