Thread: How do I auto shade every other line in a form already in use
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default How do I auto shade every other line in a form already in use
Select the range, then apply conditional formatting using the formula:
=MOD(ROW(),2)
Choose a nice fill colour, ok out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mbuet" wrote in message
...

How do I auto shade every other line in a form already in use


Reply With QuoteReply With Quote