1. R

    IF / AND with exceptions

    Hi All - Looking for help with a problem. I have an IF function with an AND inside it, the AND has multiple rules. Currently, the formula works great but I am looking for one of the AND rules to allow for an exception based on words in a separate cell. Current Formula...
  2. T

    IF/OR Usage to format cells based on given value in any set of columns

    Hi, I want to format the A column depending on the data in I J and K column so i could make 3 different Formatting rules =$I1="True" But what if i want to do I J and K in the same formatting rule? Sorry if its a bit unclear
  3. A

    conditional formating rules vba code

    Hello I tried to record a macro from conditional formating rules, but to no avail. First request, how to record a macro from conditional formating rules? Second request, please write me the vba code of the following conditional formating rules.
  4. R

    What does top 10% means in excel conditional format

    I am having problem understanding the logic of the top 10% rules in conditional formatting. What does this mean?
  5. S

    Format Painter in a Macro

    Hi guys, Im having an issue I hope someone can help me with I have my spreadsheet (which is a work of art) but I have noticed an issue using too many conditional format rules in a single cell. When I have just checked the desination cell for the format paint, instead of copying my conditional...
  6. X

    How can I simplify this?

    Hi I've managed to come up with this code: Dim v, i As Long v = Range("D2:Q" & Range("D" & Rows.Count).End(xlUp).Row).Value ' For i = 1 To UBound(v) 'N Is 20 If Left(v(i, 3), 1) = "N" Then v(i, 2) = "20" End If '0 = 20 If...
  7. S

    Import JSON into Excel 2019

    I have a Powershell script that pulls all of the Outlook Email Rules in our Office 365 Domain. I would like to output it to JSON as CSV drops columns. I have the export working fine but cannot seem to get the data to load into Excel. I have followed several videos on how to go to Data --> Get...
  8. N

    Cut/Paste in Table - Conditional Formatting

    I am cutting and pasting in a table, but this messes up the conditional formatting rules I have on the table. Is there a way (perhaps on worksheet change event) so that I can cut, copy, paste freely without affecting conditional formatting rules ? many thanks, Andrew
  9. T

    Conditional formatting nightmare

    Hi, Wondering if anyone can help or advise I have a sheet that has 3 columns with multiple conditional formatting rules to basically change the cell fill to red, orange or green depending on the date and what is in adjacent cells. The conditional formatting is working fine on my sheet but...
  10. L

    Conditional Formatting rules are cleared out after running the code

    Hi Experts - i have a problem with my code. I have a conditional formatting rules i set that highlights the cell if it has a value of FALSE or DUPLICATE. It works right after i set the rules however the rules get deleted after running below code. Do the rules get deleted by any of the codes...
  11. K

    Applying Multiple Conditional Formatting Rules

    I am applying 4 conditional formatting rules to 184 cells. I figured out how to correctly apply the formula and the colors I want but it is going to take forever doing it one at a time (that's 736 rules). Is there a way to do this more efficiently? The rules for the first cell (O7) are...
  12. N

    Average on conditional formatted cells

    Hi all I need some help I've made some rules with conditional formatting on a spreadsheet Like when true - mark as bold or mark with a blue background. Now I would like to do some calculations based on those rules. For example, I need to calculate the average of all bolded cells (and only the...
  13. S

    Creating and Managing Outlook Rules with Excel Table qty 300+

    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...
  14. W

    A complicated Data Validation question

    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> I am new to this forum so pardon me if there are any violations of the forum rules...
  15. S

    Marco to auto open folder and create 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!
  16. H

    vba macro to enable 10 outlook rules

    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...
  17. L

    Can I refer to one of my posts?

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

    Nested If w/ VLOOKUP & Ranges

    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...
  19. P

    Problem with data validation: several definitions on ONE cel, like a stack

    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...
  20. M

    Conditional Formatting - applied to field blanked out

    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...

Some videos you may like

This Week's Hot Topics