rules

Looking for a little input and suggestions before getting started, or if someone already has this, great! I receive emails that reference specific locations in the Subject line. These need to forwarded to certain people based on that location name. No problem except for the quantity. I plan to...

Hi gurus, I am trying to come up with the data validation as shown in the file attached. the rules are as follows. <colgroup><col span="12"><col></colgroup><tbody> http://tinypic.com/r/312xn2a/9 I am new to this forum so pardon me if there are any violations of the forum rules...

Hi All excel experts, May I ask if any way to create folder and rules by an excel list, use customer name as key to classific email automaticlly? 95% of the coming emails contain the full customer name, thanks!

Hi all, I need a help to build an outlook macro so that i can attached it to an outlook button to quickly turn on or off 5 of my selected outlook rules. The requirement is to enable/disable the 5 rules altogether and there is NO need to run the rule in any of the existing folders/inbox when...

Is it within rules to refer to my post that hasn't had any replies other than my own?

Hello Folks, Im looking to create a group based of the following categories with a specific set of range rules. E= IF column (e) is >5 and column (c) <5 and SUM column (es1+es2) <5 else BLANK C= IF column (c) is >5 and column (e) <5 and SUM column (es1+es2) <5 else BLANK EC= IF column...

Hello, I have a problem with Excel (2016 - Office 365). In a worksheet, I use validation. Quite simple validation: valid date input list (refering with a name to a range with the list items). There are about 15 columns with validation. On some occasion (a magic action, I'm not sure what...

Hi I have a simple range A1 to AF13 with conditional formatting to highlight specific text in the range - have about 25 rules all to fill cell with a colour for specific text. Have a worksheet for each month in the workbook. Each month I copy the worksheet and rename to the month - all been...

Hello all , I have been struggling for months to get this just right and can not seem to figure out how to do it, I was hoping maybe some of you had some ideas. here is the scenario: our company uses odd overtime rules for daily work they are as follows: any work done between midnight and 8 am...

Hi there, I would have thought since you can manage conditional rules per sheet, that sheet would have a property I could look though to see what conditions apply to that sheet. But instead it appears it is based on range? Anyhow, I just want to be able to loop though conditional formatting on...

I have created an annual leave tracker for use at work. My problem is that although you can pick from a dropdown A/L pending, A/L Approved and A/L denied, with conditional rules to change colours, at the moment anyone with access can at the moment do all three. Is there a way to ensure that only...

Hi Everyone, I'm in desperate need for a unction/rule. So, (this is embarrassing) a bunch of people are imputing dates in column G in a spread sheet; they are all different dates. These people need these dates plus 6 months to auto populate in column F. For instance: column G is 04/30/18...

have no idea to set a output of the data ,base on western electric rules 1-4 .because i am thinking to use if else statement to do this, but it can't ,for example western western electric rules 2 must have two out of three over or lower than average value...

Hey guys. Not really sure how to tackle this one. Looking to populate the highlighted cells (F15, F16, G15, G16) with the correct CMG code based on 2 rules. The rules are found in the upper table in columns D:H. Each rule is split into 3 columns, the metric specified, the operator and the...

Calculate a cell with set of rulesI want a formula to calculate K8 with these set of rules: If C8 is 0 to 25 than K8 = "Very small" If C8 is 26 to 35 than K8 = "Small" If C8 is 36 to 45 than K8 = "Large" If C8 is greater than 45 than K8 = "Very Large"

I want a formula to calculate K8 with these set of rules: If C8 is 0 to 25 than K8 = "Very small" If C8 is 26 to 35 than K8 = "Small" If C8 is 36 to 45 than K8 = "Large" If C8 is greater than 45 than K8 = "Very Large"

OK, it is worst than you thought. When I copy the data from the PDF and paste it into Excel, one PDF row turns into 4 Excel rows. It is like the data string breaks up into 4 pieces. I would like to have each PDF row be one Excel row so that I can use some delimiting rules to make this data...

Trying to use conditional formatting with 2 sets of rules. Each time I try different rules ( using AND) it never works All I'm trying to accomplish is: If C4 has no value and D4 has a value then fill C4 with a color. and down the line If C5 has no value and D5 has a value then fill C5 with a...

Hello, Please help... I need to test a list of items against a set of rules as follows: List <tbody> User System Roles John Role 1 John Role 2 John Role 3 John Role 4 </tbody> Rules <tbody> Rule System Roles System Roles Rule 1 Role 1 Role 2 Rule 2 Role 3 Role 4...

I have a large Excel document with a new tab for every day. I receive a master report via email every day and paste that report into my ongoing Excel document. Is there a way to create "rules" so the new daily report can format the same as the previous tab? Example - color filling certain...