Conditional Formatting in 2007
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.
|