View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick in NS Rick in NS is offline
external usenet poster
 
Posts: 2
Default Format Pivot Table Row Where ...

I have a fieldset containing the following fields in a pivot table as follows:

Assignments:
StaffName
CustomerName
DateJobIn
DateJobStarted

Can someone show me the code needed to loop through all the rows in the
detailed section of a pivot table and format the color of any row which the
'DateJobStarted' is greater than zero?


--
Rick in NS