Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional format cell for $0 | Excel Worksheet Functions | |||
Conditional Format Row when Value Changes in One Cell | Excel Worksheet Functions | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
conditional cell format | Excel Discussion (Misc queries) | |||
Format of one cell conditional on another | Excel Worksheet Functions |