work rota sheet

[smitz]

HIYA PEOPLE

I AM TRYING TO CREATE A ROTA TIME SHEET FOR WORK. I WANT TO CREATE I
SO THAT WHEN THE HOURS THAT ARE GOING TO BE WORKED ARE INPUTTED IN TH
PROGRAM THE CELLS WILL BE HIGHLIGHTED ON THE SHEET SHOWING THE HOUR
THAT WILL BE WORKED.
ON COLUMN A I'D HAVE STAFF NAMES;
COLUMN B I'D HAVE HOURS TO BE WORKED;
THEN FROM COLUMN D ONWARDS I'D HAVE EVERY HALF HOUR FROM 9AM TO 8P
(THESE ARE THE CELLS THAT WOULD NEED HIGHLIGHTING ACCORDING TO TH
HOURS THAT WILL BE WORKED)

HOPE YOU CAN HELP
THANK YO