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" 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.