Hey Roy,

Thanks for the reply.

I have already maxed out the CF in Excel. Here are the conditions in
the CF:

1) =AND($A2="",$B2="")
True gives light tan with light tan font, Or cell is blank.
False gives default white. Or this row has either a service date(A2),
a deposit date(B2) or both.

2)=(ROUND(SUMIF($X$2:$X$250,$X2,$E$2:$E$250),2)-ROUND(SUMIF($X$2:$X$250,$X2,$F$2:$F$250),2))0
True gives pink. Or deposit tickets missing.
False gives default white.

3)=(ROUND(SUMIF($X$2:$X$250,$X2,$F$2:$F$250),2)-ROUND(SUMIF($X$2:$X$250,$X2,$E$2:$E$250),2))0
True gives light blue. Or missing bank statement
False gives default white. Or no missing bank statement or deposit
ticket.

I still need to see if the entry is a non-bank item and if it is a
particular customer or not. Yellow means entry is this customer & a
non-bank item. While light purple means that this entry is only a
non-bank item. This is where I need the extra conditions.

I still need to find out how to get these formats onto the other 119
sheets, any ideas?

Any help is appreciated.

-Minitman



On Mon, 18 Jul 2005 17:29:03 -0700, Roy
wrote:

Minitman,

I always like to think I can test for many conditions, as long as I can live
with only 3 possible outcomes, i.e., Conditions 1, 2, and 3. What kind of
conditions are you looking for and what kind of outcomes do you need? The CF
could be implanted with vba to preserve your other existing formats, data,
and handle the variances of color from row to row, plus, you can't copy and
paste in a CF, so manual editing can be a pain (unless someone can reveal
that secret to me), especially when Excel does you a favor and throws in the
extra quotation marks after you press OK, that you really didn't need.

For example, by typing this formula into Condition 1 of cell A1, you are in
effect testing for 8 conditions at once; 10, 13, 80, OK, RED, -4, 0 (zero),
but not empty. Entering any of the above values would turn the cell the color
of your choice, but the AND statement at the end keeps the cell from lighting
up if it contains nothing, which would otherwise be considered zero.

=OR(A1=10,A1=13,A180,A1="OK",A1="RED",A1=-4,AND(A1<"",A1=0))

As long as you can live with 3 possible appearance changes for any
particular cell, it should be do-able.

Roy

"Minitman" wrote:

Greetings,

I tried this yesterday and Bob Phillips gave me a link to a 30
condition Add In at:
http://xldynamic.com/source/xld.CFPlus.Download.html

It works but I can't get it to paste down and advance the cells as the
row numbers increase (like windows normally does.

Is anyone familiar with CF Plus and could explain how to paste down?

Or does anyone have a different solution as to how to get six
conditions on each cell in a range of 23 columns by 250 rows on 120
sheets (the cells in each row have different number, color & border
formats)? I almost forgot, Many of the rows already have data in
them so I have to be careful not to erase any.

Any help would be appreciated.

-Minitman