Help Me to Conditions!

[davidtips]

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 |
+-------------------------------------------------------------------+

 

[Bob Phillips]

Use a formula like

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

using row 2 as the current row.

 

[davidtips]

Thanks Bob!

Its works just the way I want.

davidie