Thread: Coloring Alternative Rows only if data is there
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
  
Posts: 2,420
Default Coloring Alternative Rows only if data is there
=AND(COUNTA(1:1)0,MOD(ROW(),2)=1)

--
__________________________________
HTH

Bob

"BetaDocuments" wrote in message
...
Hi,

I have a spreadsheet with [ =MOD(ROW(),2)=1] conditional formatting
in it. I want to highlight this only if there data in there. I have
googled if but cannot find the method can anyone post the method or
provide me with link. It will be 2nd conditional formatting I think :l


Reply With QuoteReply With Quote