Conditional frmatting issue

[Patrick C. Simonds]

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]

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

(if A1 is the activecell)

 

[Ashish Mathur]

Hi,

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Shane Devenshire]

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.

 

[Chris Bode via OfficeKB.com]

1.Select cell A1
2.Select format>conditional 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