This should be simple so I must be over thinking the problem.

I want to set a conditional format to set a cell fill if the number in Cell
A1 is an even number.

Formula is:
=MOD(A1,2)=0

(if A1 is the activecell)



"Patrick C. Simonds" wrote:

This should be simple so I must be over thinking the problem.

I want to set a conditional format to set a cell fill if the number in Cell
A1 is an even number.

--

Dave Peterson

Hi,

You can also use the ISEVEN(cell_ref) formula in condition formatting

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Patrick C. Simonds" wrote in message
...
This should be simple so I must be over thinking the problem.

I want to set a conditional format to set a cell fill if the number in
Cell A1 is an even number.

Hi,

=MOD($A$1,2)=0

Note - if you want to set more than one cells colors based on A1 you will
need to include the $'s.

the answer one might want is (and will work in 2007)

=ISEVEN(A1)

However, ISEVEN is part of the Analysis ToolPak and in 2003 that is a
separate file which Excel won't let you reference directly. The workaround
in 2003 other than using MOD, which is good, is to define a name E which
Refers to =ISEVEN($A$1) and then choose Format, Conditional Formatting, pick
Formula is from the 1st drop down and enter =E click the Format button and
pick a color.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Patrick C. Simonds" wrote:

This should be simple so I must be over thinking the problem.

I want to set a conditional format to set a cell fill if the number in Cell
A1 is an even number.

1.Select cell A1
2.Select formatconditional formatting from the menubar
3.In the dialog box, select formula is from the drop down list to the left
3.Now in the box to the right and enter following
=MOD($A$1,2)=0
4.Click format button, choose color and click OK

Now you are done

Have a nice time

Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200902/1