View Single Post
  #7   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by Dorian74 View Post
Hi, i'm just not that creazy about the way it screws up the table i already made.
Then I would suggest you go with Claus' CF formula ( =AND(ISNUMBER(N4),N40) ) in combination with the alternating rows one you already have.