Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 16th 19, 01:42 AM
Junior Member
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 21
Default Conditional Formatting Under Multiple Conditions

How can I use conditional formatting to catch the error in Job Order 99801256 that has dept Cut and it should be Mold.I would need to use a wild card such as 9980*


Job Order Department
66105648 Cut
66102548 Cut
66102356 Cut
99805678 Mold
99806547 Mold
99806598 Mold
99801256 Cut
34565897 Trim
34569874 Trim
34568796 Trim
34568742 Trim

Last edited by Gene Haines : August 16th 19 at 01:49 AM

  #2   Report Post  
Old December 28th 20, 07:45 AM
Junior Member
 
First recorded activity by ExcelBanter: Dec 2020
Posts: 26
Default Conditional formatting with 2 conditions

1 Column, 2 Rules, 2 Conditions
Let’s assume that we have a set of different Sales Invoice data and we want to segregate invoices using conditional formatting which are either below or above $50,000. In order to achieve this, we need to follow the below steps:

Select the data range containing the invoice values, click on “Conditional Formatting” available on the “Home” tab.
Choose “New Rule” from the drop-down menu.
Choose the rule type “Format only cells that contain”. In the “Format only cells with” section, select “Cell Value” in the first drop-down box and “greater than” from the second dropdown. Write 50000 in the Value field.
Click “Format” to display the Format Cells dialog box, choose the format as per your liking.
Click “OK” for the formatting to come into effect.
After completing the above steps, the invoices having a value greater than $50,000 will be highlighted.
We have applied the first condition, now, we will move on to the application of the second condition.
The initial steps involved are exactly the same. We will again select the data range containing the invoice values then go to “HomeConditional FormattingNew rule”
Choose the rule type “Format only cells that contain”. In the “Format only cells with” section, select “Cell Value” in the first drop-down box and “less than” from the second dropdown. Write 50000 in the Value field.
Click “Format” to display the Format Cells dialog box, choose the format as per your liking.
Click “OK” for the formatting to come into effect.
The final result will be the highlighted invoice values that are either greater or lower than $50,000.

Let me know if this gave you some insights.

Regards,
Jerry

Last edited by jerry_maguire : December 28th 20 at 07:48 AM


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting, multiple conditions Wanda Excel Worksheet Functions 2 May 11th 09 08:35 PM
Conditional Formatting - Multiple Conditions with OR() EEB3 Excel Worksheet Functions 5 February 24th 08 12:10 AM
conditional formatting for multiple sets of conditions steve Excel Discussion (Misc queries) 9 August 15th 07 07:00 PM
Multiple conditions for conditional formatting plf100 Excel Worksheet Functions 4 September 27th 06 11:00 AM
Multiple conditions in Conditional Formatting guilbj2 Excel Discussion (Misc queries) 0 June 28th 06 09:09 PM


All times are GMT +1. The time now is 10:10 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017