Highlight each five rows with different colors

[YasserKhalil]

Hello everyone
I have numbers in E:N .. I need to deal with each five rows with different colors and the next five rows with the same different colors in order
I put desired results in rows 4 : 8 & rows 9: 13 ..

But sometimes there are more than five rows ... don't know how it can be adapted but we can rely on the merged cells in column A .. The maximum of these rows would be ten only

I imagine to store arrays of colors (ten colors) and store the rgb values in this array and begin to deal with the merged cells .. Hope someone helps me


Note that if there are no numbers then the row to be skipped and not colored
If possible I need the same colors exactly ..using RGB if possible

Thanks advanced for help

[Winon]

Hello YasserKhalil,

My friend, you are already so good and well experienced in Excel.

Is there any reason why you could not use Conditional Formatting?

Regards.

[YasserKhalil]

Thanks Mr. Winon
First I tried to solve using CF but couldn't figure it out
Second, I have many issues in that thread not only one issue
I am trying to solve it step by step

I will restart the issue by imagining I will deal with only five rows for each and I need to store the colors (rgb colors) in an array like that

Please Login or Register  to view this content.

but don't know how to adapt that ...
Thanks a lot for reply

[YasserKhalil]

I am trying these lines as start point

Please Login or Register  to view this content.

But I got an error at last line

[YasserKhalil]

As for this point I have overcome by using values instead of RGB values
in this way

Please Login or Register  to view this content.

Now these ten colors would be the colors for each set (the set is related to column A merged cell ... for example : A14:A20 is a merged cell so these rows from 14 to 20 rows is one set which consists of 7 rows ... so the first seven colors of the array would be used

[Winon]

Thank you for the reply YasserKhalil,

What criteria or condition is to be met where, for a range of cells to be colored, to your requirement?

[sktneer]

Hi Yasser,

Does it work for you?

Please Login or Register  to view this content.

[YasserKhalil]

That's great and wonderful Mr. Sktneer
Exactly as needed

@Mr. Winon if there is a solution with CF, I welcome that as I needed to learn
Need to adapt the different colors for each set as I illustrated

Thanks a lot for great help

[sktneer]

You're welcome Yasser! Glad I could help.
Thanks for the feedback.

[Winon]

Hello YasserKhalil,

@Mr. Winon if there is a solution with CF, I welcome that as I needed to learn
Need to adapt the different colors for each set as I illustrated

Due to the fragmented formulas with Conditional Formatting, in your specific requirement, I cannot post a prelude of same, or any Code, because VBA is not involved in this approach.

However, I believe you will appreciate the workings of the attached Sample Workbook, without offending sktneer's nice Coding.

Regards.

[YasserKhalil]

Thanks a lot Mr. Winon for this great file. I liked it a lot
You are great. Thank you very much

[Winon]

Thank you for the feedback YasserKhalil,

You are welcome, and I am glad you like it.

Thank you for the "Rep", I really appreciate it!

Have a great day.

Kind Regards.