View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Live Long & Prosper Live Long & Prosper is offline
external usenet poster
 
Posts: 5
Default 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.