I need a macro for highlighting timephased fields for hours greater than 49 hours in Resource Usage timephased weekly view RRS feed

  • Question

  • 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.

    It would also be nice to be able to place 199 in the field if we chose months instead of weeks. That might be a bit much.


    Saturday, June 4, 2011 6:06 PM

All replies