palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
I have the following spreadsheet that has frozen the top 3 rows.
I have some conditional formatting that highlights cells from column F through to column N when the now() time ... seen in cell A2 .... hits the time displayed in column C. Those cells will remain highlighted for just 5 seconds, and then the next row down will be highlighted for 5 seconds, etc etc etc..
Here is the conditional format rule ... =AND($C4<=$A$2,$C4>$A$2-TIME(0,0,5))
Is there some VBA code that will always keep the highlighted row 4 rows below the freeze line ?
For example, the image above shows the current time to be 9:18:34, so cell C97 satisfies the conditional format rule, therefore cells F97 to N97 are currently highlighted.
I need some code that would currently force row 97 to sit exactly 4 rows below the freeze line, then when row 98 becomes the highlighted row (due to satisfying the conditional format rule) it would become the row psoitioned exactly 4 rows below the freeze line.
Is this possible ?
Kind regards,
Chris
I have some conditional formatting that highlights cells from column F through to column N when the now() time ... seen in cell A2 .... hits the time displayed in column C. Those cells will remain highlighted for just 5 seconds, and then the next row down will be highlighted for 5 seconds, etc etc etc..
Here is the conditional format rule ... =AND($C4<=$A$2,$C4>$A$2-TIME(0,0,5))
Is there some VBA code that will always keep the highlighted row 4 rows below the freeze line ?
For example, the image above shows the current time to be 9:18:34, so cell C97 satisfies the conditional format rule, therefore cells F97 to N97 are currently highlighted.
I need some code that would currently force row 97 to sit exactly 4 rows below the freeze line, then when row 98 becomes the highlighted row (due to satisfying the conditional format rule) it would become the row psoitioned exactly 4 rows below the freeze line.
Is this possible ?
Kind regards,
Chris