Highlight Dynamic Rows

Hi All,

I have an issue where I need to highlight all columns which have a SAT or SUN as date.

I can do that ok, but if I insert a new row for another product everything is out of whack due to hard coding.

But I don;t know where to start to address this issue.

Can anybody steer me in the correct direction.

I have attached a workbook as to what I have done so far.

Thanks

Lionel

Perhaps this way. I have used Text function to arrive the day and used conditional formatting to highlight the holidays. See the attachment.

You can select ranges and clear the conditional formatting from there. I would suggest to use excel's built in features if that helps. See the attachment. I have removed the text function also

Select the area under dates (exluding the rows you want to spare) and run the below macro

Please Login or Register  to view this content.

if your date is not in 5th row then chnage the below

Please Login or Register  to view this content.

to your requirement

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

That was a typical snb approach . Fewer codes and better solution! Adding to my learning

Tried all three but, Oh! not really doing the job.

The code is doing the job you presented.

Proper designing precedes coding.

Hi Lionel
I'm not certain I understand the issue but, based on my understanding, try this:
In Sheet1 Module place this code

Please Login or Register  to view this content.

Replace your cmdSAT_SUN_Click code with this

Please Login or Register  to view this content.

See attached...let me know of issues.

Hi Lionel
Please post a workbook that includes this

Below that is various data reports

I need to see what these rows are and if they follow your shading scheme. The code I posted depends on finding the last row that needs shading applied.

One other thing

there are rows which are grey or white in between the coloured cells

I'm terribly color blind. I DO see the gray colored cells. If by white you mean NO COLOR then we're fine if you truly mean shaded white then I'm out of business...I don't see them.

Hi Lionel
I think I've got the Color thing figured out...it appears all cells are filled with white...unless they're not. Let me see your file with the various data reports below.

Hi Lionel
In your sample file Cell A275 says "Header 7". I need to find that row so, what does it say in the real world and does it ALWAYS say that?

Also to mention,
While the Header will always say MEASUREMENTS the cell address may not always be the same
But always Column A though.

Thanks
Lionel

Hi Lionel

This code is in the attached:
In 12-Mar Worksheet Module

Please Login or Register  to view this content.

In a General Module

Please Login or Register  to view this content.

Let me know of issues.

Why is your alias foreverlearning ?

@snb
BIG Smile...

Hi Lionel
Not a "legend"...simply looked for a connection. For your benefit, ALWAYS post a workbook that truly represents your ACTUAL file, down to the last format detail. Makes things easier to find connections and saves rewrites.

snb is quite brilliant...well beyond my expertise and understanding...I got a rather large smile from his question...I too, with the Grace of God, am "Forever Learning".

Hi Lionel
You're welcome...glad I could help.