Easy way to shade cells

[andrewc]

Hi,

I have a long list of investment fund names, some of which I want t
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 ther
will be lots of columns in the report (same as for columns A and B bu
for different measurement period) I would like to find an easy way o
shading each fund and its associated performance in the adjacent colum
without doing it manually.

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

Many Thanks

 

[Manoj]

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

 

[Ian]

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?