ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can the conditional format box be locked to the cell (https://www.excelbanter.com/excel-worksheet-functions/150836-can-conditional-format-box-locked-cell.html)

petite pied

Can the conditional format box be locked to the cell
 
When you scroll down the page the conditional format box moves aswell so it
can sit next to a cell which the condition does not apply to.
Instead can the conditional format box be locked next to the relevant cell
so when you scroll it stays with the cell it relates to?

NickHK

Can the conditional format box be locked to the cell
 
Not sure what you mean.
The Conditional format dialog is modal, so you cannot interact (scroll or
anything else) with the worksheet when it is shown.

This dialog is shown at the location that it was last at; so if you move, it
will at that location relative to the screen, nothing to do with the cell it
is formatting.
Apart from that you cannot (easily) influence its position.

NickHK

"petite pied" <petite wrote in message
...
When you scroll down the page the conditional format box moves aswell so

it
can sit next to a cell which the condition does not apply to.
Instead can the conditional format box be locked next to the relevant cell
so when you scroll it stays with the cell it relates to?





All times are GMT +1. The time now is 03:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com