rule

This happens with enough frequency that I want to get to the bottom of it. What happens is: I create a new conditional formatting ("CF") rule, inputting a simple formula to determine when the formatting should apply. I enable it, only to find that the formatting is not working as I expected it...

Hi All! I used VBA to create conditional formatting rules for a range of cells, but when I ran the macro there was no change to cells that should have been formatted. I checked to see if the code generated the rule and it did so it should have worked. What's really strange is that after...

I have a spreadsheet and am needing help splitting the data into multiple columns and adding name ranges. Spreadsheet has 5 columns (A-E) Columns C, D, and E are related. Column C contains an Inventory Name, Column D contains a Parent Rule, and Column E contains a Child rule. I need the data...

We have employees who call out sick as early as 4 am so we have an unmanned phone with voicemail where employees can call and leave message that they are sick. Those voicemails then go into the inbox (Microsoft voicemail technology) of the office assistant but she is not up that early so I...

Assume I have to rows of data. If A1 < A3, then highlight it. I can do the above for one cell but how can I extend it so this rule applies if B1 < B3, C1 < C3, etc.? Thanks

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

=NOT(ISNA(VLOOKUP(H1,Leverantorer!$A:$A,1,FALSE))) I have 2 problems I can't really get working. First is I want this formula to be used on all spreadsheets. Second problem is when I enter it into conditional formatting, save and close. It disappears. Anyone had the same problem, or is there...

Hi, I'm trying to work out how to get a symbol to pop up in a cell when two other cells contain a certain value. For example: If A1 and B1 contain x and y combination, C1 has a rule attached that inserts a particular symbol or text (doesn't matter what) for that particular combination. I'm...

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

This is my current code can anyone help to make it so all rows from the performanceEQ sheet to copy to Output with the rule copy row over if there is a data in cell B2 down, then when there is no more data in the B Column, copy the same row but with the rule IF there is data in cell D2 down...

Hello, Looking for some help with CF. My spreadsheet is used to track monthly exams for each of my workers. Here's a truncated layout: <tbody> A B C D E 1 Name Jan Feb Mar Apr 2 Worker1 100 100 100 100 3 Worker2 100 100 100 4 Worker3 100 100 100 5 Worker4 100 100 100 100 6...

I have Excel 2013. I am wanting to make a rule whereby if "Yes" is selected from a drop down menu in cell O39 on "sheet2" then the text in Cell J39 of "sheet2" will be copied to the next available row of "sheet1" if this is even possible.

So, before we get too far into this, I should say: Yes, I have done searching for this, and no, I haven't found any tutorials, guides, or tips that are helping me sort this out. I'm working on a spreadsheet (obviously), and I want to conditionally format the entire row based on the data found...

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

Hi, I have a workbook, which is nearly totally comprised of copies of one sheet, with different data entered on each. The sheet has a conditional formatting rule set up so that in certain circumstances it fills the cells in a row in in red. Unfortunately I find myself needing to recolour a...

I have two rules in a sheet I have. Once that checks if a range of cell rows (7:446) in column D equal any of the values listed in column A of a sheet titled "required_refs". If the values in those rows do match the values in the separate sheet, it'll turn that cell to a red fill background. The...

I have a live sample I can include somehow w/ Sheet 'G2-3' and Sheet 'Data'. I don't see a way to upload a file. I could upload it to my servers easy enough if needed. From Sheet 'G2-3' "Target Client Table" <tbody> Col BB Col BC Col BD Col BE Col BF Col BG IL 0 iiii 224 773...

Hello I am not very good with IF functions especially if they are nested. Could someone help me with this. My current formula in cell o9 is =IF(N9<TODAY(),1,) so that o9 returns a value of 1 I have the same in P9 but saying IF(N9>TODAY(),1,)) so that P9 returns a value of 0. However I...

Hi All, The premise I'm struggling with is to save excel attachments to folders on my PC automatically, but using a rule that looks for specific words in attachments, saves them to different folder locations. For example test in subject, in email 1, would send it to folder1. Then test2 in...