conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
In Daily,

Put in N9:
=IF(HardLines!C11<>"",HardLines!C11,IF(AND(HardLines!C11="",OR(HardLines!C12={"VAC","RO"})),IF(HardLines!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
 
Try this:

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

=IF(ISNUMBER(Hardlines!C11),Hardlines!C11,IF(AND(Hardlines!C11="",OR(Hardlines!C12={"Vac","Ro"})),Hardlines!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
 
Back
Top