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.


--
BrianDP1977
------------------------------------------------------------------------
BrianDP1977's Profile: http://www.excelforum.com/member.php...o&userid=29110
View this thread: http://www.excelforum.com/showthread...hreadid=490642