Can the conditional format box be locked to the cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top