Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Mac7000

  1. Mac7000

    lub bolt loosening on aluminum wheels

    Sorry to join this thread so late, along the same lines, the mounting face of aluminum wheels typically has a small step in it (~.20mm). This step creates a "belvil" washer effect in the joint. Two (of many) questions arise: 1) Should the lug nut draw the wheel down (or the rotor&hub...
  2. Mac7000

    Displaying cell values in different colours depending on value

    Forgive my ignorance, but how & where do I use this? Is it a macro or VB script? With Worksheets(&quot;Hoja1&quot;).Range(&quot;d8&quot;) Select Case .Value Case Is > 100 .Interior.ColorIndex = 6 Case Is < 100 .Interior.ColorIndex = 3 End...
  3. Mac7000

    Displaying cell values in different colours depending on value

    I just discovered this trick myself. However, it is limited to three conditions. Is there a way to write a Visual Basic script or something to increase the number of conditions?

Part and Inventory Search