Can the conditional format box be locked to the cell

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?
 
N

NickHK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top