Apply colour to frozen table header when rows hidden

[Togora]

Hi All,

Silly question(s) time again.

I have frozen rows 1 to 4 which contains the table header and other details.

What I would like to do is have Row 4 cells fill with red when the user scrolls down. My reasoning is it will help remind the user there are hidden rows.

So my questions are:

1. Can this be done?
2. Can it be done without using VBA?

Thanks in advance

 

[JoeMo]

Hi All,

Silly question(s) time again.

I have frozen rows 1 to 4 which contains the table header and other details.

What I would like to do is have Row 4 cells fill with red when the user scrolls down. My reasoning is it will help remind the user there are hidden rows.

So my questions are:

1. Can this be done?
2. Can it be done without using VBA?

Thanks in advance

Possibly could be done using VBA with a selection_change event macro, but if the user has selected a cell in the frozen range and simply scrolls down w/o making a selection change in tandem nothing would happen until a selection change is made. In any case, I think the answer to 2. is "No".

 

[Togora]

Hi JoeMo,

I thought that would be the case.

Thanks for the feedback.

 

[JoeMo]

Hi JoeMo,

I thought that would be the case.

Thanks for the feedback.

You are welcome - thanks for the reply.