View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Exceluser
 
Posts: n/a
Default how do I use conditional formatting for alternating cell shading?

I need to alternate cell shading based on the row number(even, odd). I need
to know how to do this using the MOD with the Row function as argument. I am
using Excel in Office XP version 2002.

Thanks