![]() |
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? |
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