Conditonal Formating to meet multiple criteria

I’m working on a project timeline in weeks.  Columns H-BG contain the (calendar) week numbers (1-52). Columns C,D,E,F will each represent 4 different categories that a user will have to enter a target date (week) under.  I would like to have the cell associated with the specific week (found in columns H-BG) to turn a specific color, based on category.  For instance, if in Column C, the number 14 was entered, the cell that falls under the 14th week in the timeline (Column U in this case) would automatically turn blue.  If I entered the number 35 in Column D, the cell in Column AP would turn green, etc.  Does this make sense?

 

 

By: Denise

Leave a Reply

Your email address will not be published. Required fields are marked *