I need a Macro for highlighting timephased fields for hours greater than 49 hours in Resource Usage timephased view

• Question

• 

  

  0

  Sign in to vote

  Hello

  Can anyone provide me some code to highlight the cell color in light green or pink if the cell value has hours greater than 49 hours and as an aside perhaps if more than 2 consecutive weeks in a row at 49 hours?

  Not sure how the code would know when to stop looking for values or how to highlight to begin with.

  I didn't see a sight for macros in MS Project

  Thanks

   

   

  Saturday, June 4, 2011 2:45 PM