conditional formatting
 

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.

conditional formatting
 

In Daily,

Put in N9:
=IF(HardLines!C11<"",HardLines!C11,IF(AND(HardLin es!C11="",OR(HardLines!C12={"VAC","RO"})),IF(HardL ines!C12<"",HardLines!C12,""),""))
Format N9 as time to taste

Then apply the CF to N9 using as Condition 1
Formula is: =OR(N9="VAC",N9="RO")
Format Yellow fill OK out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mrseje1" wrote:
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.

conditional formatting
 

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.