KevCarter
Board Regular
 Joined
 Dec 7, 2013
 Messages
 145
 Office Version

 365
 Platform

 Windows
 MacOS
Last week @Fluff posted a great formula to use when conditional formatting multiple rows in succession. It works beautifully, but I am going crazy trying to understand why...
I understand how the MOD function works when the first argument given is greater than the divisor, but why does it work when the first argument is less than the divisor? It's driving me crazy trying to understand how the early pattern is developed. Here is a sample below. Again, it works perfectly, but why?
Thank you. I hope everyone is having a very happy holiday.
I understand how the MOD function works when the first argument given is greater than the divisor, but why does it work when the first argument is less than the divisor? It's driving me crazy trying to understand how the early pattern is developed. Here is a sample below. Again, it works perfectly, but why?
Thank you. I hope everyone is having a very happy holiday.
Cell Formulas  

Range  Formula  
A2:A16  A2  =MOD(ROWS(A$2:A2)1,4)<2 
B2:B16  B2  =MOD(ROWS(A$2:A2)1,4) 
C2:C16  C2  =MOD(ROWS(C$2:C2)1,4)>=2 
E2:E16  E2  =MOD(ROWS(E$2:E2)1,6)<3 
F2:F16  F2  =MOD(ROWS(E$2:E2)1,6) 
G2:G16  G2  =MOD(ROWS(E$2:E2)1,6)>=3 
I2:I16  I2  =MOD(ROWS(I$2:I2)1,8)<4 
J2:J16  J2  =MOD(ROWS(I$2:I2)1,8) 
K2:K16  K2  =MOD(ROWS(I$2:I2)1,8)>=4 
M2:M16  M2  =MOD(ROWS(I$2:I2)1,10)<5 
N2:N16  N2  =MOD(ROWS(I$2:I2)1,10) 
O2:O16  O2  =MOD(ROWS(I$2:I2)1,10)>=5 
Cells with Conditional Formatting  

Cell  Condition  Cell Format  Stop If True  
O2:O101  Expression  =MOD(ROWS(I$2:I2)1,10)>=5  text  NO 
M2:N101  Expression  =MOD(ROWS(I$2:I2)1,10)<5  text  NO 
K2:K101  Expression  =MOD(ROWS(I$2:I2)1,8)>=4  text  NO 
I2:J101  Expression  =MOD(ROWS(I$2:I2)1,8)<4  text  NO 
G2:G101  Expression  =MOD(ROWS(E$2:E2)1,6)>=3  text  NO 
E2:F101  Expression  =MOD(ROWS(E$2:E2)1,6)<3  text  NO 
C2:C101  Expression  =MOD(ROWS(C$2:C2)1,4)>=2  text  NO 
A2:B101  Expression  =MOD(ROWS(A$2:A2)1,4)<2  text  NO 