rule

Hi All, I have the scenario where I need to automatically send a outlook email to recipients only when a email comes with specific subject to my inbox. Before sending the email to recipients, I need to get the content from the email with that specific subject and change the content. This all...

Hi all, I have column G which has a drop down list and has the following options: "June 2015" or "Septermber 2015" or "December 2015" what i would like is to create a conditional formatting custom rule so that whenever a use selectes THE MOST RECENT date option from the drop down, then this...

I have a drop down list for a whole column by which the options that you can select from are "yes" "tbd" or "n/a" however i would like a custom rule by which you can only select the option "n/a" ONLY if a previous column says "abandoned" Also please note i would like to keep the drop down list...

I have a subscription to emails which contain somewhat consistent content (CRM entries). I'm looking for a way to automate these emails (all from the same sender) to populate a single Excel spreadsheet with a row per email. I can also do a single click macro if that's easier, as I'm no VBA...

I would like to ask you if you could help me with the following. I want a rule in my Outlook to search the email's attachement for a specific word/words and in case it finds the word/words, it will move the email to a specific folder. As far as I know this is possible only using the VBA because...

Hi, I have sereval conditional formatted cells in different spreadsheets. The list of cells that have the conditional formatting applied can be seen as cells that have failed a validation rule, represented by the conditional formatting formula. ex: Cell < 0 ex: IsErr(Cell) ex: 0 < Cell < 0.2...

Is there a better way to compare lists with rules other than lots of nested IF statements? List A ------ pass unknown fail List B ------ NR (--unkown--) NF (--pass--) O (--fail--) Rules ------ If A=pass AND B=NF then Pass If A=fail AND B=O then Fail If A=pass and B<>NF then Pass/Mismatch...

I have a pivot table in 2010 I'm using conditional formatting on. For most of the cells, the conditional formatting works as designed and I don't have any issues. On one of the rows of the pivot (call it Discount), I have the formatting apply to all of those rows in the pivot as the label...

Hello I just built a spreadsheet that will add up scores for physical fitness tests the only thing is the scores get calculated differently depending on the persons age. How do I get excel to use one formula over another based on the number in the age column?

hello, i would need help in creating a rule that automatically forwards every email in the junk folder to a specific adress (there is a project to block all email marked as junk and for this we have to forward the junk email to a specific adress). in addition, i would need to permanently delete...