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?