software

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: quot;You may not use references to other
worksheets or workbooks for Conditional Formatting critereaquot;.

What am I doing wrong?]-[iseven does not appear to be a function on my version of Excel. Is it a UDF?
Regardless, the following appears to work:

=MOD($A1,2)=0

quot;Ken Zenachonquot; wrote:

gt; I'm creating a guest list.
gt; On this list, persons living at the same address are given a common ID
gt; number, unique to that address. I enter this number in column A. For
gt; readability I want records for even-numbered households to have a
gt; format of my choosing.
gt;
gt; I tried using condidtional format by selecting all the rows and
gt; entering the formula like this:
gt; Formula is =ISEVEN($A1)
gt;
gt; This results in an error: quot;You may not use references to other
gt; worksheets or workbooks for Conditional Formatting critereaquot;.
gt;
gt; What am I doing wrong?
gt;
gt;
gt; ]-[
gt;
gt;

I see from another thread that iseven is in the analysis toolpak which I am
not using which is why it did not work when I tried it.

quot;Kleevquot; wrote:

gt; iseven does not appear to be a function on my version of Excel. Is it a UDF?
gt; Regardless, the following appears to work:
gt;
gt; =MOD($A1,2)=0
gt;
gt; quot;Ken Zenachonquot; wrote:
gt;
gt; gt; I'm creating a guest list.
gt; gt; On this list, persons living at the same address are given a common ID
gt; gt; number, unique to that address. I enter this number in column A. For
gt; gt; readability I want records for even-numbered households to have a
gt; gt; format of my choosing.
gt; gt;
gt; gt; I tried using condidtional format by selecting all the rows and
gt; gt; entering the formula like this:
gt; gt; Formula is =ISEVEN($A1)
gt; gt;
gt; gt; This results in an error: quot;You may not use references to other
gt; gt; worksheets or workbooks for Conditional Formatting critereaquot;.
gt; gt;
gt; gt; What am I doing wrong?
gt; gt;
gt; gt;
gt; gt; ]-[
gt; gt;
gt; gt;