Quote:
Originally Posted by Spencer101
Then I would suggest you go with Claus' CF formula ( =AND(ISNUMBER(N4),N40) ) in combination with the alternating rows one you already have.
|
OK i found a solution with the with using the formula "N4 is between 1 and 1000"
however, i was woundering regarding pasting the formule in alternate rows. is there a way to paste it in all the alternate rows automatically not manually?