Try this:

Enter this formula in DAILY cell N9: (Format as TIME)

=IF(ISNUMBER(Hardlines!C11),Hardlines!C11,IF(AND(H ardlines!C11="",OR(Hardlines!C12={"Vac","Ro"})),Ha rdlines!C12,""))

Then set the conditional formatting
Select cell DAILY cell N9
Conditional Formatting
Formula Is: =OR(N9="vac",N9="ro")
Set your format choice(s)
OK out

Biff

"mrseje1" wrote in message
...
Hi, I asked a similar question and got a great answer, but now I have a
more
detailed question...This is what I want to do I just don't know how to
write
the formula... in a worksheet titled DAILY cell N9 to do the following: If
worksheet titled HARDLINES' cell C11 has a time listed then I want that
time
listed in DAILY N9 and nothing else, BUT IF HARDLINES C11 is blank and
HARDLINES C12 has the words VAC or RO in them, I want DAILY N9 to show
those
letters and have the background of that cell yellow.