KevCarter
Board Regular
- Joined
- Dec 7, 2013
- Messages
- 161
- 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 |