conditional format to work on every 10th row for 5 rows

[kosherboy]

Hi.
Here is a conditional formula that checks if D32 is blank and if C32 is populated then colors the row:

Please Login or Register  to view this content.

Now here is the complicated part i am trying to apply dynamically, i would like that the formula work on every 10th row for 5 rows, meaning the formula should only focus from row 32 till row 36, and from row 42 to 46, 52 till 56, 62 till 66......you get where i'm trying to get at.
Is this possible?
I have a little idea about MOD but not enough to solve above problem.

Please Login or Register  to view this content.

I would be grateful to anyone who can help me solve this.

[TMS]

This for the blocks of 5 rows from row 32 onwards:

Please Login or Register  to view this content.

[kosherboy]

This for the blocks of 5 rows from row 32 onwards:

Please Login or Register  to view this content.

HI TMS,
Wow! Thank you! cool stuff.
How do i apply this argument into your code "=AND(ISBLANK($D32),$C32<>"""")"?

[kosherboy]

i think this is correct, please let me know:

Please Login or Register  to view this content.

i tested it and it works but i'm just nervous....

Edit: Doesn't work

[TMS]

Assuming you start selecting rows for Conditional Formatting at Row 32, then

Please Login or Register  to view this content.

[TMS]

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[kosherboy]

I don't know what i did before, i completely mixed myself up
Here is the full formula:

Please Login or Register  to view this content.

All works good.

Thanks!

[TMS]

Good. Glad you got it to work