Reference to functions in Conditional Formatting

[Atreides]

Hi,

I am trying to make a reference to ISEVEN() in my Conditional Formatting.
However when I do this, Excel says that Conditional Formatting cannot make
reference to other worksheets or workbooks. I don't have this problem with
other IS.... functions, (e.g. ISERROR). When I look up Insert - Function -
Information Functions in the function browser, it lists

1. ISEVEN(Number)
2. IsEven(Number)

I'm thinking that it's this duplicated function that is confusing Excel so
that it tries to look in another workbook rather than the ready-made Function.

Both of them say "Returns TRUE if the number is even." as the description.
However if I click "Help on this function" formula 1 has a help file
associated with it whereas 2 doesn't. I'm thinking that 2 is either a:

a) function I defined myself (not realising it was already defined), or
b) function included in an add-in

Investigating option a, I can't find any reference to "IsEven" in any of my
code for this workbook or for my personal workbook that stores my macros.

For option b, I have the following add-ins loaded:
- Analysis ToolPak
- Analysis ToolPak - VBA
- Internet Assistant VBA
- Lookup Wizard
- Solver Add-in

Would any of these be causing it? Or option c, d, e etc. that I haven't
thought of? Please help!

Thanks

- Atreides

 

[Norman Jones]

Hi Atreides,

I think that the IsEven function is included
with the Ansalysis Toolpack add-in and is,
therefore, not treated as a native function.

Try replacing IsEven with

=MOD(A1,2) = 0

 

[Atreides]

Hi Norman

Interestingly, taking off Analysis Toolpak - VBA (no Analysis Toolpak) does
make IsEven disappear from the functions list. However it still causes the
same problem with conditional formatting even after I save and restart Excel.
Is there some other process required to "reset" Excel to remove references to
functions?

Your Mod trick does work though, thanks.

Atreides