View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
mrseje1 mrseje1 is offline
external usenet poster
 
Posts: 3
Default i need help with conditional formating with dates

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!