You will need to use simple IF statements to check whether the time is blank.
Something like this

if(A1="","" ,sheet2!A2)

Hope it helps
Eddie
--


Alwyas Trying
Eddie


"mrseje1" wrote:

I'm trying to link daily schedules to fill in automatically from information
entered into a weekly schedule. I have two conditional formatting questions
1.if a time is left blank on the weekly schedule and I need it to remain
blank on the daily I need to ... right now it automatically puts in 12:00 AM
on the daily if the weekly is left blank.
2.I want to place the letters RO or VAC in some time spaces on the weekly
and have the daily repeat that with a color or pattern fill, how do I do this?

Thanks so much for your help!