View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
MICHELLE1 MICHELLE1 is offline
external usenet poster
 
Posts: 4
Default Alternating every other row different colors

Thank you, thank you, thank you!! It worked!!!!!!!

Sebation.G wrote:
u can use the codtional formatting.
1 set the worksheet backgroud color :green
2 use the conditional formatting
formula:"=mod(row(),2)=0"
the backgroud color set pink

I have a very large spreadsheet created in Excel. I am trying to alternate
every other row grren and then Pink. However, I can't seem to figure out

[quoted text clipped - 5 lines]
me
with this it would be greatly appreciated. Thank you...!