Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

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

Search results for query: *

  1. TornadoWilkes

    Pivot Table VBA Conditional Format on PivotField

    Lol Again, works a treat... for a newbie here I'm in awe lol Ian Developer
  2. TornadoWilkes

    Pivot Table VBA Conditional Format on PivotField

    Skip You're a superstar, I would never have guessed that's where you reference. It now works a treat apart from the OK or Complete for Green. I've got as a formula: =OR(SEARCH("OK",E11)>0,SEARCH("Complete",E11)>0) Which doesn't work on OK's although...
  3. TornadoWilkes

    Pivot Table VBA Conditional Format on PivotField

    Cheers Skip I guess I'm struggling knowing what to use as the CellRef. I'm attempting to use the pivot as a cube, and in the past have put conditional formatting into each field allowing the pivot to be reorientated or new dimensions added and the formatting sticks after the refresh. Likewise...
  4. TornadoWilkes

    Pivot Table VBA Conditional Format on PivotField

    Cheers Skip I'll have to work out how to attach on this site, but here's a Tab delimited sample version of the data that can be pasted into Excel and converted to columns.. Project Number Project Name Project Decription Project Manager Country 1 - Project Mandate 2 - Initiation 3 - Go/No Go 4...
  5. TornadoWilkes

    Pivot Table VBA Conditional Format on PivotField

    Hi I've been searching for days all over the web and then remembered you guys. I wondered if anyone could help me with this please? I have a PivotTable that tracks whether or not projects are completed on time. Against each project number are 5 columns (pivot fields not the data section) that...

Part and Inventory Search

Back
Top