rule

Hi, I have this conditional formatting rule: =AND($W2<>0,$W2<>"") It is applying a light green fill color when the conditions are met. What I would like to do is have every group of 14 rows alternate between this color and a slightly different color. Is it possible to setup another...

Hi Everyone, A bit of a different one, I just want to know how remove duplicates decides which duplicates to remove? Lets say I have 5 duplicates so rows 1 to 5. if I remove duplicates does it remove 1 to 4 and leave 5? 2 to 5 and leave 1? or is it random of some other rule? thanks Tony

Hi to all, I am a teacher attempting to perform some magic apparently beyond my abilities. The goal is simple: isolate numeric data found within parentheses in a text string via a formula to then highlight a cell presenting said data within a range. Here is what I have so far: Excel 2016...

Hi all! On a MAC Is it possible to duplicate an existing conditional format rule? I have to create 30 rules and don't want to have to create each 1 from scratch. I could swear that I was able to do the many years ago. Thank you!

Hi I downloaded one of Mike Girvin sheet and he wrote the following: "Excel;s Golden Rule: If a formula input can change, put it in a cell (with a label next to it) and refer to it in the formula with a cell reference" I could not understand what he meant? Any help would be very much appreciated.

What would the formula be for the following, in using conditional formatting (to determine cell to format). I can't seem to use both in the same rule. I even tried doing them separately in their own rule but no go. Here is my statement ... Greater than 1 (>1) but Less than 10 (<10). Exactly...

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

I have a spreadsheet and it uses when the data imports it displays Ex- ".87 (ft)". having the text and parenthesis in the cell give me an error on the output of the program. There are thousands of these measurements, so I am looking for a quick way to accomplish this.

Hello , I Have a Tabel which there are alot of cells , for Example i have 2 cells which i wanna to make a validation rule between them : Account Number & Clearance Code i wanna to create a rule if the clearance code = any value , when i try to write any account number it shows a msg that we...

Good afternoon all. I'm wondering how to simplify conditional formatting so that I don't have to edit the rule every time I add a new pair of columns to my sheet. My formula looks at each row, if a value exists in "F", but not in "G", then color "G" red. Again for "H"+"I", "J"+"K", etc. Right...

Hello I have a workbook with information on two tabs, that I would like to create a conditional format rule to highlight the cell in the first tab if the value is different in the other tab. The first tab is "Accrual" the cell that would have the rule in it is in column Q (there are several...

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

Hi, I am just after a little help in fixing a formatting rule that I have written as a conditional format that I have written for QA work. Here is the code I have written: =OR(AND(SEARCH("missing",K1),M1="No"),AND(SEARCH("lost",K1),M1="No")) Basically I want the format to highlight when a...

I have data at 200 cells in column A starting from cell A11 ending at cell A210. At column B there are data at 30 cells starting from B11 ending at B40. The cells of column B have a connection with cells of row A. Cells B11:B30 should be every 10 cells in column A, this means B11 should be one...

Hi I have 4 columns in a table which are Name. Dept, Address, Phone# I want to create a conditional formatting rule. If a user enter in cell H1=Name then excel will highlight the name column in red, if user enter H1=Address then excel will highlight Address column in green etc. How I did it, I...

I have the following formula: =INDEX(client_CTA_co_organization_regi!$S$2:$S30000,MATCH($B2&$C2,client_CTA_co_organization_regi!$B$2:$B30000&client_CTA_co_organization_regi!$C$2:$C30000,0)) It looks compares an email field between the client_CTA sheet and the email field in column J. I have...

Hi All, I'm trying to create validation rule where only value in upper cases "MUKESH" would be allowed in field. this is what I'm trying with - Is Null OR Not Like "*[!a-z]*" but not seem to be work . Note : I know I can format field with ">", so that whatever user enters it will turn into...

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 the following macro: Sub verificaCNP() Dim lr As Long lr = Range("A" & Rows.Count).End(xlUp).Row For Each c In Range("G3:G" & lr).Cells If c.Value <> "" Then c.Activate ActiveCell.Interior.ColorIndex = xlColorIndexNone If Len(ActiveCell.Value) <> 13 Then...

Good morning! I am trying to create a rule that achieves the following: If Column C says "Yes" and/or Column D says "Yes" then say "Yes" in column E. This is what I was using but it is erroring out on me, and I am not sure what else I need to use. Thanks...