Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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, 11 views)
Reply With Quote
 

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 07:33 AM.


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