Hi,

I have a long list of investment fund names, some of which I want to
shade a particular colour. The data is arranged as follows:

Col A - fund names
Col B - performance for each fund in column A

Of this list of some 20 funds I want to shade about 8 of them. As there
will be lots of columns in the report (same as for columns A and B but
for different measurement period) I would like to find an easy way of
shading each fund and its associated performance in the adjacent column
without doing it manually.

Can someone please suggest a clever way of doing this easily?

Many Thanks!


--
andrewc
------------------------------------------------------------------------
andrewc's Profile: http://www.excelforum.com/member.php...o&userid=19613
View this thread: http://www.excelforum.com/showthread...hreadid=552586