.patterncolorindex

  1. J

    macro formula/conditional formatting

    here is my macro. I have to highlight rows that only have the word "pad" in column M only. I changed it to M:M but it highlighted several columns that did not have the word pad in it. Selection.FormatConditions(1).StopIfTrue = False Cells.Select Selection.FormatConditions.add...
  2. B

    If a cell contains 'x' then select row to left and clear formatting through loop

    Hi, This is my first ever post - scary stuff! I've been hard at learning VBA for both excel and word for the past year to help me create massive efficiencies in my day to day duties at work. Currently, I'm working on an excel sheet that is a snapshot of projects that are currently being run...
  3. E

    Selecting the Last Row in multiple columns

    Hi, I am using the below formula to select cells for conditional formatting: Range("A2:A45,F2:F45").Select Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=$B2=$F2" Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority With...
    • Edkins
    • Thread
    • .patterncolorindex .tintandshade f2f45.select rangea2a45 type=xlexpression
    • Replies: 2
    • Forum: Excel Questions
  4. S

    VBA Help - Conditonal Formatting dynamic Range Comparing other cell values

    Good afternoon, I am working on a macro for tracking training dates and notifying the user when training needs to be scheduled. Currently I have my macro doing the following conditions: -Determines the last row used in the worksheet to know the range to apply the formats to -Apply the...
  5. E

    Solution for Highlighting Rows for Ease of Viewing

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...
    • ephillips
    • Thread
    • .patterncolorindex .tintandshade end type=xlexpression xlautomatic
    • Replies: 0
    • Forum: Excel Questions

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
Back
Top