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

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