Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |