sorry, i'll remember that next time

--


Gary


"Tom Ogilvy" wrote in message
...
Gary,

It would seem useful to alert the OP that you are directing him/her to a
commercial site where he/she can purchase a product to assist their need.
Generally this forum is used to provide programming assistance and not
tout
commercial products. It would have been most appropriate if you had
said,
I highly recommend this product which can be purchased at so and so. Most
URL's posted here are to informational pages.

Just my opinion of course. You are certainly free to post anything you
want.

--
Regards,
Tom Ogilvy



"Gary Keramidas" wrote in message
...
you can check this out
http://www.ozgrid.com/Services/excel...nal-format.htm

also, in the next version of excel:
Number of conditional format conditions on a cell
Old Limit: 3 conditions
New Limit: Limited by available memory

--


Gary


"Floyd" wrote in message
oups.com...
All:

I am attempting to use either a user-defined function in VBA or a
spreadsheet function to conditonally shade a cell.

I would use Excel's conditional formatting; however, it is limited to
three conditions.

Also, I can do this with VBA. Unfortunately, then I would have to
re-refernce the subroutine when the data is moved. Given the dynamics
of this spreadsheet, I would be required to do this often.

Is there anyway to use something like this,IF(A1=1, ColorIndex=1, "") ,
to conditionally format a cell?

Thanks in advance.

Floyd