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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Text Time to Time 2
Colour format code 2
Samsung 840 Pro SSD 256 GB 0
Set variable date range in query? 1
How to make the application wait until ODBC Extract is finished 2
Games you've not finished? 8
can i have 2 scales in one line chart? 4
VLOOKUP gets wrong value 3

Back
Top