You're doing nothing wrong other than trying to use another workbook.

ISEVEN is a Function from the Analysis Toolpak add-in hence the "other
workbooks" message.

Try the formula given by Mark.


Gord Dibben MS Excel MVP

On 19 Jan 2006 14:46:18 -0800, "Ken Zenachon" wrote:

I'm creating a guest list.
On this list, persons living at the same address are given a common ID
number, unique to that address. I enter this number in column A. For
readability I want records for even-numbered households to have a
format of my choosing.

I tried using condidtional format by selecting all the rows and
entering the formula like this:
Formula is =ISEVEN($A1)

This results in an error: "You may not use references to other
worksheets or workbooks for Conditional Formatting criterea".

What am I doing wrong?


]-[