Font color question

[BrianDP1977]

My cell font color hopefully... but maybe not.

I have a range of names (DP6_Names). Equated with each name is a start date. All these dates are on the same row as their respective name and are defined as the named range DP6_Date_Start. There is another list of names (range Alt_Names) which may or may not contain the same name as one in the DP6_Names range of names. I need to define the font color used for the name in DP6_Names based on this logic:

If the name in DP6_Names is also a name found in Alt_Names, the DP6_Names font color for that specific name should be light orange. No other conditions should apply after this.

If the start date month for the respective DP6_Names name is either 12, 1, or 2 (i.e. DEC, JAN, FEB) the font color should be red.

If the start date month for the respective DP6_Names name is either 3, 4, or 5 the font color should be sea green.

If the start date month for the respective DP6_Names name is either 6, 7, or 8 the font color should be blue.

If the start date month for the respective DP6_Names name is either 9, 10, or 11 the font color should be black.

I kind of know how to do this with conditional formatting except there are two problems. First, I don’t have enough conditions. However, more importantly, I need to be able to copy the name cell values formatting on other sheets (i.e. the defined font color) and if I used conditional formatting the font color would not be able to be referenced directly from the cell. Thank you for the help.