Thank you for the fantastic video on explaining conditional formatting. Your presentation skills are excellent. Following your guidance, I implemented conditional formatting for every 14th row, beginning with row 2. Here's the format I used: =MOD(ROW()-2,14)=0 Thanks again
It was amazing to learn with you. Thanks for helping us learn! I have a scenario where I have data in Column B2 to H2 and Row 2 to Row 10. I want to highlight every 4th row, but I don't want to highlight the entire 4th row, only from Column D2 to F2. Is it possible to highlight in this way? The thing to remember is that the data is in Excel worksheet not in table
Chris, Thanks for this hard to find info... Can you also combine a second argument? Like if you want the formatting to apply only to every Nth column ? E.g., in the case of every third column and every 2nd row, it would be : A2, A4, A6, ..., D2, D4, D6, ... G2, G4, G6.... J2, J4, J6... etc...
Hi, can you help me? I'm trying to highlight every1- 7th cel, 7-14 cel etc in a row from a specific date on column A, for example, 06/17 plus 6 days (yellow), then from 8th to 14th (green) cel until the end of the month. The columns are the days of the month until the 31st
@ChrisMenardTraining I want to highlight every 15 rows but have the highlight stay with the row when I sort. I have been doing it manually, but it is time consuming. The table may work for what I am needing to do though
Hey, deinem Namen nach bist du Deutsch: Ich hatte das gleiche Problem: Bei der deutschen Excel-Version muss man irgendwie ein Semikolon ; statt einem , machen. Keine Ahnung ob dir das noch was bringt, haha
this is so good thank you so much!
Thank you for the fantastic video on explaining conditional formatting. Your presentation skills are excellent. Following your guidance, I implemented conditional formatting for every 14th row, beginning with row 2. Here's the format I used:
=MOD(ROW()-2,14)=0
Thanks again
Big Thanks!! This is exactly what I was looking for. Works perfectly!
You're welcome!
You saved me so much time. Thanks for sharing!
You are welcome!
Thank you Sir 🙏
It was amazing to learn with you. Thanks for helping us learn! I have a scenario where I have data in Column B2 to H2 and Row 2 to Row 10. I want to highlight every 4th row, but I don't want to highlight the entire 4th row, only from Column D2 to F2. Is it possible to highlight in this way? The thing to remember is that the data is in Excel worksheet not in table
Chris, Thanks for this hard to find info... Can you also combine a second argument?
Like if you want the formatting to apply only to every Nth column ?
E.g., in the case of every third column and every 2nd row, it would be : A2, A4, A6, ..., D2, D4, D6, ... G2, G4, G6.... J2, J4, J6... etc...
Tx, but border are gone after this formatting, even if you select neutral color
Hi, can you help me? I'm trying to highlight every1- 7th cel, 7-14 cel etc in a row from a specific date on column A, for example, 06/17 plus 6 days (yellow), then from 8th to 14th (green) cel until the end of the month. The columns are the days of the month until the 31st
Is there a way to do this that stays with the line when sorted? It doesn't with conditional formatting and it takes forever to do it manually
When I use Conditional Formatting, I can sort, and the CF remains. You could use a Table if you want every other row selected
@ChrisMenardTraining I want to highlight every 15 rows but have the highlight stay with the row when I sort. I have been doing it manually, but it is time consuming. The table may work for what I am needing to do though
Thanks, what if I wanted to highlight the first seven rows, then have 7 unhighlighted rows, then 7 highlighted rows again?
Here you go drive.google.com/file/d/1DxQ4Xh9zFoVG1Qb8uHjg0srnTNgXOOUl/view?usp=drivesdk
@@ChrisMenardTraining Legend, thanks mate!
How to apply it if Excel is not in english?
Formulas are sadly language specific.
I get an error: There's a problem with this formula. What am I doing wrong?
Hey, deinem Namen nach bist du Deutsch: Ich hatte das gleiche Problem: Bei der deutschen Excel-Version muss man irgendwie ein Semikolon ; statt einem , machen. Keine Ahnung ob dir das noch was bringt, haha