Before
Projects |Dates
100101 |17-Jul-2005
100101 |19-Jul-2005
100102 |01-Apr-2005
100102 |30-Jul-2005
100102 |31-Jul-2005
100103 |29-Jul-2005
100104 |17-Jul-2005
100105 |17-Jul-2005

After
Projects |Dates
100101 |17-Jul-2005
100101 |19-Jul-2005
100102 |01-Apr-2005
100102 |30-Jul-2005
100102 |31-Jul-2005
100103 |29-Jul-2005
100104 |17-Jul-2005
100105 |17-Jul-2005

I need help to create a macro to color code the project numbers. In
this example 100101 has two projects...I would like to color the 1st
two letters of both projects red to know that there are 2 projects
with this project number when i do a filter. A second example; there
are three project 100102, I would like the first three digits red to
know that there are three projects with the same project number as this
one. etc...

Any help is appreciated.
Thx.


--
mister z
------------------------------------------------------------------------
mister z's Profile: http://www.excelforum.com/member.php...o&userid=28099
View this thread: http://www.excelforum.com/showthread...hreadid=476359