Per Jessen wrote in
:

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.



I'm not looking for the values that are even (divided by 2), I'm looking
for vlaues that have 0 as a remainder. In the above example here are the
top 10 results {a1 thru a10 has 50,000,000/row()}:

50,000,000.00
25,000,000.00
16,666,666.67
12,500,000.00
10,000,000.00
8,333,333.33
7,142,857.14
6,250,000.00
5,555,555.56
5,000,000.00


I want the ones that end in zero to be highlighted :)