I have consective numbers in column A. In column B is formula =isodd
which returns True or False, and this works for me but I have tried to
use =isodd and =iseven as a conditional format formula with no luck.
My question is, is it possible to use either of these arguments in a
conditional format formula. I have tried severial syntax with no luck.
I most often get error message "May not use referance to other sheet
or book...." I know you guys can crack this.

Regards

BigD

I most often get error message "May not use referance to other sheet or
book...."

That's because those functions are part of the Analysis ToolPak add-in which
is another file (workbook).

For even numbers:

=MOD(A1,2)=0

For odd numbers:

=MOD(A2,2)0

--
Biff
Microsoft Excel MVP


"BIG D" wrote in message
...
I have consective numbers in column A. In column B is formula =isodd
which returns True or False, and this works for me but I have tried to
use =isodd and =iseven as a conditional format formula with no luck.
My question is, is it possible to use either of these arguments in a
conditional format formula. I have tried severial syntax with no luck.
I most often get error message "May not use referance to other sheet
or book...." I know you guys can crack this.

Regards

BigD

I don't know the formula isodd, but you can use this formula:
=MOD(A1,2)=1
which gives you false for any even and a true for any odd number.

hth

Carlo

On Nov 20, 2:12 pm, BIG D wrote:
I have consective numbers in column A. In column B is formula =isodd
which returns True or False, and this works for me but I have tried to
use =isodd and =iseven as a conditional format formula with no luck.
My question is, is it possible to use either of these arguments in a
conditional format formula. I have tried severial syntax with no luck.
I most often get error message "May not use referance to other sheet
or book...." I know you guys can crack this.

Regards

BigD

Do you need the =1, Carlo? Can't you just use =MOD(A1,2) ?
--
David Biddulph

"carlo" wrote in message
...
I don't know the formula isodd, but you can use this formula:
=MOD(A1,2)=1
which gives you false for any even and a true for any odd number.

hth

Carlo

On Nov 20, 2:12 pm, BIG D wrote:
I have consective numbers in column A. In column B is formula =isodd
which returns True or False, and this works for me but I have tried to
use =isodd and =iseven as a conditional format formula with no luck.
My question is, is it possible to use either of these arguments in a
conditional format formula. I have tried severial syntax with no luck.
I most often get error message "May not use referance to other sheet
or book...." I know you guys can crack this.

Regards

BigD

Can't you just use =MOD(A1,2) ?

Yes, you could. I included the 0 in my reply just to show some uniformity
with the even numbers formula.

=MOD(A1,2)=0
=MOD(A1,2)0


--
Biff
Microsoft Excel MVP


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Do you need the =1, Carlo? Can't you just use =MOD(A1,2) ?
--
David Biddulph

"carlo" wrote in message
...
I don't know the formula isodd, but you can use this formula:
=MOD(A1,2)=1
which gives you false for any even and a true for any odd number.

hth

Carlo

On Nov 20, 2:12 pm, BIG D wrote:
I have consective numbers in column A. In column B is formula =isodd
which returns True or False, and this works for me but I have tried to
use =isodd and =iseven as a conditional format formula with no luck.
My question is, is it possible to use either of these arguments in a
conditional format formula. I have tried severial syntax with no luck.
I most often get error message "May not use referance to other sheet
or book...." I know you guys can crack this.

Regards

BigD

On Nov 20, 12:56 pm, "T. Valko" wrote:
Can't you just use =MOD(A1,2) ?

Yes, you could. I included the 0 in my reply just to show some uniformity
with the even numbers formula.

=MOD(A1,2)=0
=MOD(A1,2)0

--
Biff
Microsoft Excel MVP

"David Biddulph" <groups [at] biddulph.org.uk wrote in ...



Do you need the =1, Carlo? Can't you just use =MOD(A1,2) ?
--
David Biddulph

"carlo" wrote in message
...
I don't know the formula isodd, but you can use this formula:
=MOD(A1,2)=1
which gives you false for any even and a true for any odd number.

hth

Carlo

On Nov 20, 2:12 pm, BIG D wrote:
I have consective numbers in column A. In column B is formula =isodd
which returns True or False, and this works for me but I have tried to
use =isodd and =iseven as a conditional format formula with no luck.
My question is, is it possible to use either of these arguments in a
conditional format formula. I have tried severial syntax with no luck.
I most often get error message "May not use referance to other sheet
or book...." I know you guys can crack this.

Regards

BigD- Hide quoted text -

- Show quoted text -

Thanks everyone! The formulas work and solve the problem nicely.
In response to Valko I do have the analysis tool pack installed on all
of my machines which makes me wonder if the isodd command is for some
reason not available in conditional formating. I do not know enough
about excel to test the command in cf but I am researching it.

Regards

BigD

Since ATP is an add-in it exists physically on another sheet and you cannot
refer to other sheets when doing CF unless you use a defined name. You can
bypass ATP by putting ISODD in another cell hidden from view, or even better
in another sheet, for instance if the cell you want to CF is in Sheet1

=ISODD(Sheet1!A1)

if you put that in another sheet and call that cell for ODD
(insertnamedefine)

then you can select A1 in Sheet1 and use

=ODD=TRUE

and the CF will work

now you can hide this particular sheet with the isodd formula and nobody
will have a clue


--


Regards,


Peo Sjoblom


"BIG D" wrote in message
...
On Nov 20, 12:56 pm, "T. Valko" wrote:
Can't you just use =MOD(A1,2) ?

Yes, you could. I included the 0 in my reply just to show some
uniformity
with the even numbers formula.

=MOD(A1,2)=0
=MOD(A1,2)0

--
Biff
Microsoft Excel MVP

"David Biddulph" <groups [at] biddulph.org.uk wrote in
...



Do you need the =1, Carlo? Can't you just use =MOD(A1,2) ?
--
David Biddulph

"carlo" wrote in message
...
I don't know the formula isodd, but you can use this formula:
=MOD(A1,2)=1
which gives you false for any even and a true for any odd number.

hth

Carlo

On Nov 20, 2:12 pm, BIG D wrote:
I have consective numbers in column A. In column B is formula =isodd
which returns True or False, and this works for me but I have tried
to
use =isodd and =iseven as a conditional format formula with no luck.
My question is, is it possible to use either of these arguments in a
conditional format formula. I have tried severial syntax with no
luck.
I most often get error message "May not use referance to other sheet
or book...." I know you guys can crack this.

Regards

BigD- Hide quoted text -

- Show quoted text -

Thanks everyone! The formulas work and solve the problem nicely.
In response to Valko I do have the analysis tool pack installed on all
of my machines which makes me wonder if the isodd command is for some
reason not available in conditional formating. I do not know enough
about excel to test the command in cf but I am researching it.

Regards

BigD