Works fine for me.

Select a bunch of rows starting row 1 and then do Format / Conditional
Formatting, change 'cell value is' to 'formula is' and either use your
formula or perhaps =AND($A1<"",MOD($A1,2)=0) if you don't want the blank
rows to appear as flagged.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"hhunt" wrote in message
...
I apologize if this is a duplicate post, not sure what happened to the
post I
was working on.

I have a spreadsheet with a column of numbers... the rest of the data is
text or dates. What I am trying to do is shade the row that contains an
even
number in the column that contains the numbers.

I've been able to shade the cell that contains the even number by choosing
only the column with the numbers, and using the following in the
conditional
format:
=MOD($A1,2)=0
However, when I try to select all and apply the exact same formula
(thinking
it would only look at column A)... the entire spreadsheet gets shaded.

I'm very new to conditional formatting - any ideas?

Thanks!