@Combination functions to Grade timelines in Excel Gantt

Khadd3243 no problem, that is why we volunteer.  so I didn't see any conditional formatting on the sheet so i added 2 rules.  Each was Applied to columns H:CK as shown in the conditional rules manager box below:

You can also see the formula that it is using on the left.

BTW, I formatted both the text color and background color the same so all those "X" and "Y" values 'disappear'

To modify, just click the 'Edit rule...' button and you will get a box like this:

you can see on the upper half that the 'Format only cells that contain' option was selected and on the lower half I specified Cell Value = "Y" as the condition.  To modify the formatting options like the text color and background color just click the Format button.

You can also see the last option on the upper half says "Use a formula to determine which cells to format" and that is the custom formula option I mentioned earlier whereby you could use the conditionals that determine if the cell should be an "X" or "Y" to DIRECTLY determine if that cell should be Dark Green or Light Green.  If you ever decide to use that, just remember to make the formula based on the upper left corner cell from the Applies To section just like the formula you made to be inside the cell before you fill down and fill right.

Hope that all helps.