Chip Pearson wrote in
:

Select A1:A100 and then open the Conditional Formatting dialog. Choose
"Use a formula" and enter the following formula:

=INT(A1)=A1

and then choose your formatting. If your range does not start in A1,
change both instances of A1 in the formula to the first cell in the
list of cells. Excel will automatically change the A1 references to
A2, A3, etc for the cells in the selected range.

This will format those cells in A1:A100 that are integers.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com





On 16 May 2010 22:09:34 GMT, "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.


Simple once ya know how. In the past (finger poking problems no doubt) I
couldn't get that to work. It would ALWAYS put $A$1 in all 100 boxes,
now it does not. Any hoo, THANKS!