Re: Conditional Formatting in 2007

You do not need your formula in A1 and down.

Just select A1:A100, goto Format > Conditional Formatting > Formula
is: '=Mod(Row(),2)=0'

Select formatting as desired.

Regards,
Per

On 17 Maj, 00:09, "Live Long & Prosper" <sp...@the.helm> wrote:
> Playing with Excel I'm trying to conditionally format cells that divided
> evenly in a range, heres a simple example
>
> In cell A1 I put '=50000000/row()' I then extend (drag) that for 100 rows.
> What I'd like to do is then select A1:A100 and conditionally format so the
> ones that divded with no remainder are highlighted.
>
> I can't figure out how to format a whole range with a formula.