rules

I work with audit rules that are being populated from a financial database (Concur) into an excel sheet. There are different rules being applied to different organizations. I need to compare the overall data in sheet2 that has the names of the codes for the organization that are auto populated...

Hi guys I don't know if the below is enough for people to suggest any improvements, but I wanted to ask if I can write the below in a more efficient way? its a if statement going through different rules...

Hi and thank you ahead of time for helping me figure this out. Situation: -cell A1 has CF that imposes a gray fill color is the cell is BLANK -Need to have VBA code that changes that color to Black based on certain conditions Dilemma: -When the VBA conditions are no longer, how do I get the CF...

Feel like I'm going batty / missing something obvious. Read a cool trick to be able to toggle Conditional Formatting ("CF") on/off to see if that might be what's bogging down my file speed: simply create a new rule and move it to the TOP of all the rest of your CF rules, and click the "Stop if...

So in trying to troubleshoot my laggy file, I got rid of all Volatile functions (which I understand to be speed killers), only to learn that the #1 culprit may in fact be the 120 conditional formatting (CF) rules I have, which my research indicates are always volatile, which I guess makes...

question 1: I have inherited a spreadsheet that has multiple conditional formatting rules. The first 10 are what I want. There must be near 100 rules that have developed over time (not likely intended), mostly one or two cell ranges. Is there a way I can clear the unwanted rules without doing...

I have been looking for information on this and have not been able to find any. At least not the "rules" for getting this to work properly. I work with excel on a daily basis in a professional capacity and want to be able to use GETPIVOTDATA at times but some tables don't allow it and instead...

Hello all Below is some code that runs all my rules in outlook and works very well Is there a way to not activate the rule on emails that are Red Flagged "Follow ups" as I don't want to lose sight of these. The issue I have is the rules drop all my emails into my hard drive email folders to...

Hello all, I have a spreadsheet (A3:AE25) I would like to conditionally format based on a specific rule type. First Two row are headers that arent to be touched. Column C houses rules anywhere from 1-20. As an example, Rule 1 requires fields D3 and F3 to have a value so I would want this...

I have a worksheet that has a few conditional formatting rules applied to full columns(ie C1::C1048576) and have noticed when I'm copying cells or range of cells, new rules are added to the list of conditional rules so I end up with a bunch of duplicated rules. Say there is a conditional...

Hello Community, I am injecting some data form Excel from into Access DB. The problem is when user puts some BAD value. SQL return en error with type mismatch in the background and data is not INSERTED into DB. I would like to validate data that is being injected into Access using Validation...

I'm currently using conditional formatting with these rules: =K2<=TODAY() This is for expired dates. Cell is red, font is white. =AND($K2>TODAY(), $K2-TODAY()<=30) This is for upcoming expiration dates within 30 days. Cell is orange, font is black. =AND($K2>TODAY(), $K2-TODAY()<=90) This is...

I have two conditional formatting rules. One highlights games that only appear once in a sheet, the other checks to see if the games exist in a list on another sheet, if so they turn yellow or green, respectively. The problem is some games satisfy both rules. I’d like to create a third rule...

Is it possible to apply the resulting formats of a number of conditional format rules to a cell via code? I have a process that copies out a number of sheets and these sheets rely on a value in a sheet that doesn't get copied out and therefore, when the new file is created all the conditional...

Hello, I'm running into an unusual situation in Excel (v 2016 Professional Plus). Upon entering data into cells, I am noticing random borders being drawn around the cell and row. I checked for any "Customized Formatting" rules and none are enabled for the entire sheet yet this behavior still...

I have a workbook that i use every day. i did some conditional formatting on a few cells that if the value is equal to the value on a different page the cell will turn a color. Everything works as it should until I save the workbook, It wont save the conditional formatting rules. I have no clue...

Ok. Not an excel master here but am somewhat familiar with formulas. Admittedly, I have never worked with conditional formatting before so most of this has been trial and error and google. I have a database with multiple columns of data. I need to highlight entire rows based on the presence or...

Separately they work fine, but I have a bunch so combining these rules would be fantastic. =AND($M101="Male", NOT($H101="TN")) =$H101="KY" Both my attempts won't work :( =OR($H101="KY"),AND($M101="Male", NOT($H101="TN")) =AND($M101="Male", NOT($H101="TN")),OR($H101="KY") Is there ANY...

Hi all! I inherited a spreadsheet of 100 rows/50+ columns that has simple conditional formatting rules in it. Unfortunately, the CF rules were build using $E$7, so if I copy the CF to other cells they continue to be compared to $E$7. I would like to change it to $E7 so that when I copy the CF...

Hello All, I'm a bit stumped on how to solve a particular data problem and was hoping for a nod in the right direction. I have a table, which along the top going across columns has some unique codes in row 1, and some categories attached to those codes in row 2, which are populated using a...