Right now I'm using a long formula in a conditional format to color
cells based on information in the column prior to the previous column
(coloring cells in column C based on information from column A, for
example).

This is what I'm using to do this:
=AND(D180,OR(D18=F1,D18=F2,D18=F3,D18=F4,D18=F5,. .. and so on
This will color the cell if it is greater than 0 and equal to any cell
in column F.
well, it is supposed to, at least.

However, I can only input so many characters into the string which only
allows me to compare up to around row 30, and my data set is between
50-70 rows.

My next thought would be to use a macro, but I know very little about
them and was wondering if someone could lend me a hand.


--
rbmcc
------------------------------------------------------------------------
rbmcc's Profile: http://www.excelforum.com/member.php...o&userid=30602
View this thread: http://www.excelforum.com/showthread...hreadid=530485