Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-01-2011, 11:10 PM
Learner7 Learner7 is offline How can I get the conditional result? Windows XP How can I get the conditional result? Office 2007
Advanced Beginner
How can I get the conditional result?
 
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
File Type: jpg Condtional Formatting.JPG (9.3 KB, 1 views)
Reply With Quote
  #2  
Old 02-02-2011, 03:16 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline How can I get the conditional result? Windows 7 32bit How can I get the conditional result? Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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...
Attached Files
File Type: zip Example.zip (3.1 KB, 0 views)
Reply With Quote
Reply

Thread Tools
Display Modes


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
How can I get the conditional result? Checkbox on Userform result in Text in Word Dolfie_twee Word VBA 1 06-22-2010 07:54 AM
How can I get the conditional result? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft