I guess that BJ was correct: you can't use functions from ads-ins in the
conditional formatting (<--can any one confirm that?).
That is not what BJ said.
You can use your own functions in Conditional Formatting.
The functions in the Analysis Toolpak are not builtin, and
are like using your own functions, and using addins.
The problem with the Analysis Toolpak is that you must
turn them on with Tools, Addins, Analysis Toolpak
and not everyone is going to have them on. Memory
requirements would not be much of a consideration as
in the past.
Beege changed the formula to builtin functions rather than
forcing anyone to turn on the Analysis Toolpak, but
=MOD($A2,2)=0 produces TRUE for EVEN numbers
Conon (original poster) noted that the formula should be
=MOD($A2,2)=1 to work same as ISODD (for integers only)
The fact that you cannot reference cells outside the current worksheet,
may be what what was confusing you -- nothing to do with addins or the
Analysis Toolpak, and you can actually get around that
restriction by using named ranges .
My page on Conditional Formatting is
http://www.mvps.org/dmcritchie/excel/excel.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Conan Kelly" wrote in message
I guess that BJ was correct: you can't use functions from ads-ins in the
conditional formatting (<--can any one confirm that?).
"Beege" wrote ...
"Conan Kelly" wrote
I'm trying to use the following formula in conditional formatting in cell A2 when the range A2:AW64 is selected (this
conditional
formatting will be copied to all cells in the selected range):
Formula is: =isodd($A2)
The error I keep getting is this:
"You may not use references to other worksheets or other workbooks for Conditional Formatting criteria."
I'm trying to use this conditional formatting because column A is our "Order" column. "Order" can be from 1 to 13 and this
column is sorted ascending. There can be multiple rows in each Order number. So I want to shade all 1's, 3's, 5's, etc... so
that each Order group has alternating shading.
I also want to use conditional formatting, not VBA, to get this to work. In the future, rows might be added to an Order number
or
two and I want the shading to automatically adjust.
What is going on here? Does anyone know how to get this to work?
--
Thanks for any help anyone can provide,
Conan Kelly
Conan,
Try Condition format / formula is / =MOD($A2,2)=0
Beege