Thread: How do I set up alternate row shading with Excel 2003?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default How do I set up alternate row shading with Excel 2003?
Hi,
Select all data you want to alternately shade.
In conditional Format, Formula is:
=MOD(ROW(),2)=0
Set desired shading format.
OK
Regards - Dave
Reply With QuoteReply With Quote