Thread: how can I get excel to fill using a start and finish time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default how can I get excel to fill using a start and finish time
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" wrote in message
...

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.




Reply With QuoteReply With Quote