Thread: Background color for every other row
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
[email protected] rgoubet@yahoo.fr is offline
external usenet poster
  
Posts: 6
Default Background color for every other row

a écrit :

Stefi wrote:

You can use Conditional formatting for the required selection with this
formula:
=MOD(ROW(),2)=0

Conditional formatting is defined according to the cell's value, not to
a testing formula... Where should I input the formula?

Forget it! I found it... Actually, it's even better because the
striping will remain even if inserting new rows!

Thanks!

Raph

Reply With QuoteReply With Quote