SOLVED
Home

Help with Conditional Formatting?

%3CLINGO-SUB%20id%3D%22lingo-sub-364933%22%20slang%3D%22en-US%22%3EHelp%20with%20Conditional%20Formatting%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364933%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20that%20contains%20data%20about%20the%20weather%2C%20obtained%20from%20a%20device%20which%20records%20that%20data%20every%20hour%20on%20the%20hour.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20conditional%20formatting%20formula%20which%20adds%20a%20bottom%20border%20to%20every%2024th%20row%20to%20separate%20the%20days%2C%20making%20the%20table%20easier%20to%20read.%3C%2FP%3E%3CP%3ETHE%20PROBLEM%20is%20that%20%3Dmod(row()%2C24)%3D0%20will%20include%20the%20first%20three%20rows%20of%20the%20worksheet%20which%20is%20my%20header.%3C%2FP%3E%3CP%3EThe%20question%20then%20is%20how%20do%20I%20get%20the%20formula%20to%20skip%20the%20first%20three%20rows%20of%20the%20table%2C%20and%20THEN%20start%20formatting%20every%2024th%20row%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-364933%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EConditional%20Formatting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-364947%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Conditional%20Formatting%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364947%22%20slang%3D%22en-US%22%3E%3CP%3E%3Dmod(row()-3%2C24)%3D0%20Did%20the%20trick%2C%20thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-364946%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Conditional%20Formatting%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364946%22%20slang%3D%22en-US%22%3E%3CP%3ELike%3C%2FP%3E%0A%3CPRE%3E%3DMOD(ROW()-4%2C24)%3D0%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
CaffeineKing
New Contributor

I have a table that contains data about the weather, obtained from a device which records that data every hour on the hour. 

I need a conditional formatting formula which adds a bottom border to every 24th row to separate the days, making the table easier to read.

THE PROBLEM is that =mod(row(),24)=0 will include the first three rows of the worksheet which is my header.

The question then is how do I get the formula to skip the first three rows of the table, and THEN start formatting every 24th row?

2 Replies
Solution

Like

=MOD(ROW()-4,24)=0

=mod(row()-3,24)=0 Did the trick, thank you!