rules

Is there a way to copy the "appearance" of a range of cells without any of the formulas or the conditional formatting rules? I have a row of values that are the result of formulas and several conditional formatting rules. The resulting values have a variable number of decimal points and then...

Hello all I have piece of code which when activate moves all my emails into the emails folders where the rules have been set up This works great but is there a way to not move any emails that I have RED flagged as I don't want to lose sight of these until they have been actioned Sub...

Hello All There are some new features installed today: vbOptimise - using regis caching to speed page load Like/Thank posts - If you like a particular reply to a post, you can like the post. Anything with > 5 likes will appear in a special color Cookie Control - to be compliant with the EU...

I have a spread sheet that I want to set a conditional formatting on column C. Rules: =AND(D1<>"", C1="") Condition: turns cell yellow this is working but if I grab (as an example) C15 and drag it down to C18 to copy a value to the cells below, it causes the conditional formatting to get all...

HeyI've tried to make a formula but can't get it to happend. I use a formula to count words/names and it works fine:=SUM(COUNTIFS(C63:C72,{"*Mike*","*Peter*","*Jane*","*Even*","*Jack*"}))But my problem is that beside counting the words then I also neet to have the types beside.Eks; cell A1...

Hi there, I am working with a contact list of over 3,000 individuals. I need to remove people from the list who don't have either an address OR email. If they have one or the other, or both they remain on the list. Is this possible? My current method is to use the Ctrl+G option > Go To Special...

I want excel to automatically create an hyperlink every time it finds a specific word on a column... so everytime the text in question appears a new hyperlink to the same destination will be automatically created... can i???

Hi Folks, I'm devising a new dual rota at my work and I want to automate it as much as possible. We have two offices and a mixture of experienced and newer staff. The rota will consist of Primary and Secondary staff (in columns D & E) and I have put staff names into the following named ranges...

I have been asked to create a spreadsheet that will calculate a Data Retention Date depending on a number of elements. The Field Names & Rules would be as followed: Field 1: Enter DOB Field 2: Age (Calculated on Field 1) Field 3: Enter Date of Initial Review Field 4: Enter Date of Follow Up...

if I want to formating some cells by specific rules , how can I do to fulfill it ?? suppose: range("i2") represent some value , like 2.33 and I want some range of value , which < 2.33 , are formating become some color such as： if range("b2:F2") < range("i2")...

I have a quote template that has about 8 sections to it, each section I have given a named range of Range1, Range2 and so on. I need a macro that will do the following: - Reset Page Breaks - Add page breaks as normal but do not split a Range up (so put the break at the beginning of the range...

Hi, I'm looking to implement a rule so that when a specific resource is selected for an assignment, a check is done through the existing data to see whether they are already 'booked' for work within that calendar period. I've put together an example here...

All, I'm having an absolute nightmare with conditional formatting. I had a spreadsheet that updated small amounts of data by copying and pasting everytime you moved between sheets. Thanks to Excel duplicating conditional formatting rules, the spreadsheet completely fell over because I ended up...

Dear Smartest Excelers In The World. I am writing a book for Holy Macro! Books Publishing about Array Formulas. I am making this post in hopes that I could get some feedback about some array formula concepts. Below are five questions that I have for all of you, the smartest Excel people that I...

Hi all, hopefully someone can help me as I'm going round in circles trying to get this to work as I want.:confused: I have 2 columns (A and B) of data side by side, some values positive, some negative. I need a formula in Column C that will compare the first 2 columns and give me a text output...

Is there a way to establis a cell to be coloured if certain criteria are met. For example if the varaince between the actual sales each month drops below the target sales can I colour the name of the individual that did not make the required target?

Hi, When you are linking two spreadsheets together, is it possible to carry over the conditional formatting from one spreadsheet to another? I type in = and click in a cell with conditional formatting on Spreadsheet 1 I want the conditional formatting in the Spreadsheet 1 to carry over to...