View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
broro183[_19_] broro183[_19_] is offline
external usenet poster
 
Posts: 1
Default Color every second row ?


Hi, try again...
SpookiePower Wrote:
I cant make the most simple one of them to work.
Either all the rows are white or I get this error message -
http://www.activewebsite.dk/excel.jpg
and then it point at ,2 in the line =MOD(ROW(),2)=0
I'm using excel 2003


Have another look at the example, all that needs to be entered is
"=MOD(ROW(),2)", your picture shows that you have typed
"=MOD(ROW(),2)=0".

The "=0" is not needed.

hth
Rob Brockett
NZ
always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=503235