How can I get the conditional result?

Learner7 · #1 02-01-2011, 11:10 PM

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.

Colin Legg · #2 02-02-2011, 03:16 AM

Hi,

Quote:

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

You cannot do this with conditional formatting. Conditional formatting changes the format of the font/fill within the cell only. However, you can do this with a simple IF() formula.

You do not state what message should be displayed if the Order Value is equal to the Invoice Value, so I will assume it should say "Process the Invoice". One possible formula is this:

Code:

=IF(A2>=B2,"Process","Hold")&" the Invoice"

I have attached an example for you.

Hope that helps...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using conditional formatining to change to all caps	Shades	Excel	3	05-05-2014 06:05 AM
Conditional formatting of Today +21 days?	SHERMAN	Excel	3	12-20-2010 08:08 AM
Checkbox on Userform result in Text in Word	Dolfie_twee	Word VBA	1	06-22-2010 07:54 AM
Conditional formatting of cell, Excel 2003	Scaffold	Excel	2	05-01-2010 08:56 AM
Challenge!! Need help though. (Conditional formatting)	knuckles70	Excel	2	02-05-2010 12:24 PM