View Single Post
  #6   Report Post  
Domenic
 
Posts: n/a
Default

You mean it works? I didn't think that was possible. It certainly
doesn't work on my version of Excel. Hmmm...

Would you mind sending me a sample so that I can have a look at it?

In article ,
"Sam via OfficeKB.com" wrote:

=IF((ROWS(I$19:I19)<=ROWS(Position))*(MOD(ROW()-ROW(I$19)+1,3)=0),3,"")

I used the above Formula in the Conditional Formatting Formula Is, to produce
the Conditional Format Red Cell Interior and number 3 in the Cells at the
same time.