excel highlighting cells

Hi everyone

I was looking for some help with a spreadsheet I am working on, its a staff rota that lists the staff down the left column and the days across the top, each day has three columns associated with it, start time, finish and total hours worked (if the staff member is not scheduled on that day it is left blank)
I am creating another sheet that looks at a day, individually for example monday, with the staff down the left and the hours in that day along the top for example 07:00 07:30 08:00 what i want it to do is to look up the rota sheet and highlight is some way the hours each staff member work that day, so if staff member 1 starts at 10:00 and finishes at 13:00 the cells 10:00 10:30 11:00 11:30 12:00 12:30 will highlight some way and the rest of the days hours will be blank, if the staff member is not working All the hours will be blank. Has anyone any ideas as I am at a bit of a lose as to how to get started

Any help would be great
Cheers
Jackie

Have you tried using conditional formatting? It might be helpful if you attached a spreadsheet with an example of what you would like to see

Hi

I have attached an example of what I am trying to do, sheet named rota is the staff rota on the sheet marked wednesday I want is to look something like this, where is looks up the sheet rota and if the empoyee is working it highlights it like this, nopt really sure what is the best way to do this any advice would be great

Cheers

Jackie

Hi I had a look at conditional formating and got it working for me cheers