formula1

  1. D

    vba to insert copied row below row of a specific value

    I'm new to VBA but trying to learn and wrap my head around the way vba works. What I need can be seen below: <tbody> Formula1 Formula2 Formula3 Formula4 1234 Step1 Step2 Step3 DOG Complete Formula1 Formula2 Formula3 Formula4 5678 Step1 Step2 DOG Formula1 Formula2 Formula3 Formula4 4321...
  2. M

    rogue row in pivot table - "Formula1"

    I've inserted a pivot table and in the row labels column one of the labels is 'Formula1'. I don't have any rows labelled formula1 - where the heck is this coming from!
  3. E

    Conditional Formatting with VBA and xlExpression Formula1: with VBA Variables and Text

    Hello Mr. Excel! I want to start by saying a quick thank you! I love this site. I have tried to find answers in previous posts but I haven't found anything to find material that applies directly here, yet. I've been using VBA to new worksheets that compile information from a "Source"...
  4. D

    Iterating through Conditional Format Formulas not working as expected

    I read Bill's "VBA and Macros in Excel 2007" chapter on Conditional Formatting. That said, I'm finding that iterating through the ConditionalFormats.Formula1 collection to not work as expected. For example, a cell shows in the User Interface the following three rules: Rule 1...
  5. R

    VBA Conditional Formatting Formula Simple Error

    I am having problems with my code snippet below. I am almost certain that the error lies in Formula1:=CStr(ucl.Address). I can get the code to work by changing it to ucl.Value, but I need the formatting to be linked to the ucl CELL, not it's value, so that it will update when the value in...
  6. S

    FormatConditions.Add for xlExpression & formula - fails!

    I can't seem to get this conditional formatting code to work. Error:Run-time error '5' Invalid procedure call or argument xlCellValue works: With .Range("tblGlobalData[Response Time]").FormatConditions _ .Add(xlCellValue, xlEqual, "FAIL") .Font.ColorIndex = 3...
  7. L

    FormatConditions Formula1 differences between 2003 and 2007

    Step1: Select range 'A1:B5' Step2: Fill with numbers Step3: Apply this FormatCondition: Formula '=A1=2', with Red Font. Then, all cells with contains number 2 are Red. Step4: Select cell 'B2' In VBA, Excel 2003: Msgbox ActiveCell.FormatConditions(1).Formula1 shows: '=B2=2' In VBA, Excel...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top