conditional formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mrseje1 - 01 Nov 2006 23:40 GMT

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 to this Message

Max - 02 Nov 2006 04:28 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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
[quoted text clipped - 3 lines]
> 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 to this Message

Biff - 02 Nov 2006 04:54 GMT

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

> Hi, I asked a similar question and got a great answer, but now I have a
> more
[quoted text clipped - 7 lines]
> those
> letters and have the background of that cell yellow.

Reply to this Message

Rate this thread: