Thread: Loop within Conditional Formatting

Hi All,

I am creating a schedule template for my company and I am designing an aspect of it that highlights the dates of any Milestones that are part of a certain task.

I want the "calendar" area of a task (e.g. T10:CX14 for task 1) to search through the milestones (shown for presentation purposes in T72:BU82; but for calculation purposes, i've converted it into a simpler table below), find any and all milestones that pertain to that task and highlight the correct date. I have figured out how to basically hard code searching for these tasks - you'll see the blue highlighting in the calendar area - but I want the conditional format to be smart enough to work with any number of milestones.

I tried a vlookup for this, but vlookup stops searching after it finds one value. Sumifs only works if i want to add the values (they're dates, it's not helpful.)

If anyone could take a look at the sheet and try and figure out what I'm trying to do, it would be an enormous help to me. Please don't hesitate to modify how the milestones are shown there's an easier way to do this than what I'm thinking.

Progress Report No. 1.xlsx

Happy New Year to all,
DAF

If you are ok with putting formulas in the cells (you can hide the values easily enough if need be), then you can do something like the attached. I have only done the first task - hopefully you can see what was done and apply it to the rest.