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.