View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
snah snah is offline
external usenet poster
 
Posts: 2
Default How to change every second row with different color - Excel 20

Thank you Bob
But if I put the code in my table I get an formula error.
Works this code by you?

=MOD(ROW(),2)=0

In Excel input field are marked those characters: ,2

Thanks Jan

Bob Phillips pÃ*Å¡e:

See http://www.xldynamic.com/source/xld.CF.html#rows

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"snah" wrote in message
...
I have a simple table and I would like to have every second row in
different
color.
How can I make it?
Thanks