Microsoft Office Forums - View Single Post - [Solved] How can I get the conditional result?

Thread: [Solved] How can I get the conditional result?

View Single Post

Old

02-01-2011, 11:10 PM

Learner7

Learner7 is offline

Learner7 uses Windows XP

Windows XP Learner7 uses Office 2007

Learner7 uses Office 2007

Office 2007

Advanced Beginner

The original poster

Join Date: May 2010

Posts: 51

Learner7 is on a distinguished road

Default

How can I get the conditional result?

Hi,

How can I get the result as in attached .JPG file using conditional formatting:

If the "Order Value" is higher than the "Invoice Value" --- Then the cell to be filled with "Process the Invoice" .... otherwise it is to be filled with "Hold the Invoice".

How can I do that? Please help.

Thanks.

Attached Images

Condtional Formatting.JPG (9.3 KB, 11 views)

Reply With Quote