Format Row If Cell Contains Even Number

[Ken Zenachon]

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?


]-[

[Kleev]

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

"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?
>
>
> ]-[
>
>

[Kleev]

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.

"Kleev" wrote:

> 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
>
> "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?
> >
> >
> > ]-[
> >
> >