Thread: Alternating Changing Color of Cells (a Range) across a Spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Alternating Changing Color of Cells (a Range) across a Spreadsheet
Hi Jeff,

Using conditional formatting , Formula Is :
=MOD(ROW(),2)=0
and pick your color ...

HTH
Carim

Reply With QuoteReply With Quote