|
|
#1
02-01-2011, 11:10 PM
|
|||
|
|||
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. 
|
|
|
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 |
Windows XP 
Office 2007
Threaded Mode