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

Try using the conditional formatting. It will work well with these kind of
requirements of yours.

"andrewc" wrote:


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

Conditional formatting only permits 3 conditions. The OP requested 8 of 20.
Even an IF statement in an adjacent column wouldn't work because that is
limited to 7 nested Ifs.

It is probably going to need a VBA solution, but I'm not sure how to go
about that. Perhaps someone else can help?

--
Ian
--
"Manoj" wrote in message
...
Try using the conditional formatting. It will work well with these kind
of
requirements of yours.

"andrewc" wrote:


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