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