Conditional Format if cell value is odd

's Computer Specifications

Hi all,

Does anyone know how to do this?

Thanks a bunch,

Michele

's Computer Specifications

Please state your question in the body of the message, not in the subject.

=ISODD(A1)

Tyro

"mjones" <(E-Mail Removed)> wrote in message
news:c6bc0e02-00c7-4d33-b85b-(E-Mail Removed)...
> Hi all,
>
> Does anyone know how to do this?
>
> Thanks a bunch,
>
> Michele

's Computer Specifications

If the cell value you want to check is A1, then:

formula is =mod(A1,2) = 0

hope that helps

Carlo

On Feb 12, 10:05*am, mjones <mich...@quality-computing.com> wrote:
> Hi all,
>
> Does anyone know how to do this?
>
> Thanks a bunch,
>
> Michele

's Computer Specifications

That formula produces TRUE if the cell value is even, not odd.

Tyro

"carlo" <(E-Mail Removed)> wrote in message
news:fa4093ec-5869-4f99-b42a-(E-Mail Removed)...
If the cell value you want to check is A1, then:

formula is =mod(A1,2) = 0

hope that helps

Carlo

On Feb 12, 10:05 am, mjones <mich...@quality-computing.com> wrote:
> Hi all,
>
> Does anyone know how to do this?
>
> Thanks a bunch,
>
> Michele

's Computer Specifications

ISODD is not a standard function - requires ATP to be installed with
versions before XL2007.

Pete

On Feb 12, 1:12*am, "Tyro" <T...@hotmail.com> wrote:
> Please state your question in the body of the message, not in the subject.
>
> =ISODD(A1)
>
> Tyro
>
> "mjones" <mich...@quality-computing.com> wrote in message
>
> news:c6bc0e02-00c7-4d33-b85b-(E-Mail Removed)...
>
>
>
> > Hi all,
>
> > Does anyone know how to do this?
>
> > Thanks a bunch,
>
> > Michele- Hide quoted text -
>
> - Show quoted text -

's Computer Specifications

So? Install ATP.

Tyro

"Pete_UK" <(E-Mail Removed)> wrote in message
news:55ad3810-22f8-4fff-8b8c-(E-Mail Removed)...
ISODD is not a standard function - requires ATP to be installed with
versions before XL2007.

Pete

On Feb 12, 1:12 am, "Tyro" <T...@hotmail.com> wrote:
> Please state your question in the body of the message, not in the subject.
>
> =ISODD(A1)
>
> Tyro
>
> "mjones" <mich...@quality-computing.com> wrote in message
>
> news:c6bc0e02-00c7-4d33-b85b-(E-Mail Removed)...
>
>
>
> > Hi all,
>
> > Does anyone know how to do this?
>
> > Thanks a bunch,
>
> > Michele- Hide quoted text -
>
> - Show quoted text -

's Computer Specifications

If you do not wish to install the Analysis Toolpak, you may use
=MOD(A1,2)<>0 to determine if a cell is odd and =MOD(A1,2)=0 to determine if
a cell is even

Tyro

"mjones" <(E-Mail Removed)> wrote in message
news:c6bc0e02-00c7-4d33-b85b-(E-Mail Removed)...
> Hi all,
>
> Does anyone know how to do this?
>
> Thanks a bunch,
>
> Michele

's Computer Specifications

You may also use =ISODD(A1) if you are using Excel 2007. You did not state
what version you are using.

Tyro

"mjones" <(E-Mail Removed)> wrote in message
news:c6bc0e02-00c7-4d33-b85b-(E-Mail Removed)...
> Hi all,
>
> Does anyone know how to do this?
>
> Thanks a bunch,
>
> Michele

's Computer Specifications

"Tyro" <(E-Mail Removed)> wrote in message
news:VG6sj.57015$(E-Mail Removed)...
> If you do not wish to install the Analysis Toolpak, you may use
> =MOD(A1,2)<>0 to determine if a cell is odd and =MOD(A1,2)=0 to determine
> if a cell is even
>
> Tyro
>
>
> "mjones" <(E-Mail Removed)> wrote in message
> news:c6bc0e02-00c7-4d33-b85b-(E-Mail Removed)...
>> Hi all,
>>
>> Does anyone know how to do this?
>>
>> Thanks a bunch,
>>
>> Michele
>
>

's Computer Specifications

> =MOD(A1,2)<>0 to determine if a cell is odd

Or even... =MOD(A1,2)=1

Rick

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Capture conditional format as cell format	Diddy	Microsoft Excel Misc	2	23rd Jun 2009 11:01 PM
conditional cell format based on cell in same row, previous column	=?Utf-8?B?dGFtaWx1Y2hp?=	Microsoft Excel Worksheet Functions	7	3rd May 2006 04:11 PM
Creating a conditional format for a cell based on another cell's v	=?Utf-8?B?c3RldmUtbw==?=	Microsoft Excel Misc	2	26th Oct 2005 03:51 PM
Conditional format - how can I format a cell based on a DIFFERENT cell's value?	Shiperton Henethe	Microsoft Excel Discussion	2	19th Nov 2004 05:11 PM
Conditional Format with VBA - Interior Colour of cell based on value from in-cell dropdown	Steve	Microsoft Excel Programming	5	15th Jun 2004 11:45 AM