Help Me to Conditions!
 

:confused: Hi there!

File attached.

How can I set my Condition Formating at *Column C* (Item Name) to be
able to show indication (boxed RED) if one or more required infos (F &
G) is missing?

As *Column E* (Shipped Date) will be the trigger factor for these
required infos.

*For exmple1:* Row 4, Orange is boxed RED becuase the shipped date was
entered, but QTY is missing.

*For exmple2:* Row 6, Durian is not boxed RED becuase there is no
shipment yet.

Thanks!!

davidiew


+-------------------------------------------------------------------+
|Filename: 123xx.doc |
|Download: http://www.excelforum.com/attachment.php?postid=3579 |
+-------------------------------------------------------------------+

--
davidtips
------------------------------------------------------------------------
davidtips's Profile: http://www.excelforum.com/member.php...o&userid=19103
View this thread: http://www.excelforum.com/showthread...hreadid=385148

Use a formula like

=AND(E2<"",OR(F2="", G2=""))

using row 2 as the current row.

--
HTH

Bob Phillips

"davidtips" wrote in
message ...

:confused: Hi there!

File attached.

How can I set my Condition Formating at *Column C* (Item Name) to be
able to show indication (boxed RED) if one or more required infos (F &
G) is missing?

As *Column E* (Shipped Date) will be the trigger factor for these
required infos.

*For exmple1:* Row 4, Orange is boxed RED becuase the shipped date was
entered, but QTY is missing.

*For exmple2:* Row 6, Durian is not boxed RED becuase there is no
shipment yet.

Thanks!!

davidiew


+-------------------------------------------------------------------+
|Filename: 123xx.doc |
|Download: http://www.excelforum.com/attachment.php?postid=3579 |
+-------------------------------------------------------------------+

--
davidtips
------------------------------------------------------------------------
davidtips's Profile:
http://www.excelforum.com/member.php...o&userid=19103
View this thread: http://www.excelforum.com/showthread...hreadid=385148

Thanks Bob!

Its works just the way I want.

davidiew


--
davidtips
------------------------------------------------------------------------
davidtips's Profile: http://www.excelforum.com/member.php...o&userid=19103
View this thread: http://www.excelforum.com/showthread...hreadid=385148